Record limits in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What are the maximum number of records that Access 2003 can have?
I believe this is related to memory size. If so, what is the formula.
 
Hi,

The help facility does not really give you information to calculate max
number of records. There is no formula and there is no max number of
records.

An Access database can be up to 2GB in size (however many records get you
there). Also, by using link tables you can circumvent this size limitation,
since you can link to multiple Access databases.

HTH,
Immanuel Sibero
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What makes people want to buy this NetBook 2
About Access limits 15
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
access 2.0 limts 2
Import Data from Excel - Size Limits 4
Export Record Limitations 1
Maximum record size and maximum number of records 3
File size in Access 2003 3

Back
Top