Access 2003 limits

  • Thread starter Ãåùñãßïõ Ãéþñãïò
  • Start date
Ã

Ãåùñãßïõ Ãéþñãïò

Hi

I would like to know the maximum mumber of records and fields that you can
store in a table.
 
N

Nikos Yannacopoulos

George,

Max. number of fields in a table is 255. There is no limit to the number
of records, the limit is total .mdb file size <= 2GB.
Look up "Access specifications" in Access help for more details.

HTH,
Nikos
 

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

"The Pattern String is Invalid" 1
Maximum record size and maximum number of records 3
Add autonumber to a large table? 0
About Access limits 15
access 2.0 limts 2
Report Error 2
What are the Access 2007 record table limits? 2
Significant data per record 1

Top