Max record size

[strangeryet]

I have to add many new fields to a table.
The current record size is 646 bytes long and would increase to 1735.
I am trying to decide which is the best course of action:
Add all the fields to the record, or break the record up into different tables, indexed by a unique key.

Is 1735 bytes too long?

This is using Jet not SQL server

Thanks
Mike

 

[KenReay]

See Specification in help for exact information relation to your version of Access

but from memory max number of columns is 511 and max recordsize is 4096 bytes

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[strangeryet]

Thanks