Number of records in Access

W

Woz

If your question is how many records can access have (max
sorage) I do not remember the exact amount but it's a bit
over a gig. At least that's when it stopped importing off
my Oracle and SQL 2000 database. So I make a couple
smaller database files and then just linked them up. Local
sorts / joins ex on over 15GB of data and not problems. I
would just suggest you do it on a server class computer.

:)
 
B

Brendan Reynolds \(MVP\)

Access 97 had a 1GB maximum file size, later versions increased that to 2GB.
But note that is file size, not number of records. There's no direct
relationship between file size and number of records. The size of a record
can vary widely, depending on the number and data type of the fields.
 

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

Copy previous record into form field 0
MS Outlook inbox to MS Accsess Database 0
Deleting records from a table 3
tabs, relationships and records in forms 25
Access database suddenly huge 1
Record limit CSV import and more - Access 2002 SP3 1
Sorting records in an Access table for real 3
Access Database size limits linking to SQL server 6

Top