what is the maxmun number of records in access 2003

  • Thread starter Thread starter megapluskha
  • Start date Start date
M

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
 
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/
 
Back
Top