what is the max number of records for access 2000&2003 table?

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

Guest

what is the max number of records for access 2000&2003 table?

In access 2000 when we go over 15000 records in a table it corrupt
 
Randy said:
what is the max number of records for access 2000&2003 table?
Click to expand...

It's not how many records, but how much space they take. Each table in
Access 2000 can hold 1 GB, and each table in Access 2003 can hold almost 2 GB.
The maximum database size for both versions is 2 GB.
 

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 is the max number of records for access 2000&2003 table? 7
What is the max number of... 4
Record-Locking remains open after closing 0
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access 2003 and SQL2000 Table Problems 1
MS Access cant change the data type ; there is not enough disk space or memory. 4
DELETE FROM a table WHERE... 1

Back
Top