Maximum Table Size

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

Hi,

What is the maximum number of records you can have in a
table in Access 97?

I'm importing postcode data into a table and there are c.
8 million records.

The primary key is a string that will be large enough to
be unique for all the records.

Cheers,
Ian
 
There is no specification for maximum number of records per table or
database. Access 97 allows for a maximum database size of 1 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

Limit 4
How to export table from outlook into ms access table? 0
News 419m phone numbers leaked in Facebook data breach 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
MS Access Avoiding redundancy 1
Maximum Tables? Maximum Fields/Columns Per Record? 7
Creating a key consisting of two columns 1
data merge 0

Back
Top