max records in access2000 table?

J

James Goodman

Yes. Taken from the help file for AccessXP (2002)
Access specifications
Microsoft Access database specifications
Access database

Attribute Maximum
Microsoft Access database (.mdb) (Microsoft Access database: A
collection of data and objects, such as tables, queries, or forms, related
to a particular topic or purpose. The Microsoft Jet database engine manages
the data.) file size 2 gigabytes minus the space needed for system objects
(system object: Database objects that are defined by the system, such as the
table MSysIndexes, or by the user. You can create a system object by naming
the object with USys as the first four characters in the object name.).




I dont think this will apply in the same way to an Access project which has
a SQL Server database.

I am not sure what would happen if you tried using access to connect to a
SQL Server DB >2GB...
 

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

Top