what is the maxmun number of records in access 2003

[megapluskha]

i am disigening a database for my clints, there are more than 50000 clint so
i am asking if there is a record limit in access 2003 or i can enter with no
limites

 

[Jeff Boyce]

Yes, there is a limit. No, the limit isn't related to the number of
records.

Each record has a limit of approximately 2000 bytes, if I recall correctly.

Each Access database file has a limit of 2 Gbytes, if I recall ...

Check Access HELP, look for "specifications" for the numbers relevant to
your version.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/