Maximum Size for a DB?

[snagrat]

Is there a maximum size a database can be?

Or a maximum number of records a table can hold?

or will it allow you to add as many records as you like until the hard drive on the compute is full?


cheers

 

[Travis]

Access 97 has a 1 G.B. Limit

Access 2000 has a 2 G.B. Limit

I believe MSDE and SQL Server is somewhere in the Terabytes. (you would definatly want some good Indexes in this case)

 

[Autoeng]

By entering "Access specifications" in Access help you get all of the specs.

 

[ghudson]

I can not find "Access specifications" in Access 97.

Check this out for more info about db limitations...
Some common Access specifications

HTH

 

[jeremie_ingram]

There are several workarounds to the size restrictions of a access database. If you find that a single table is exceeding the limitation size for your version, and you cannot break it down to smaller tables, then you need to look into something along the lines of SQL or Oracle (or whatever you can afford and use efficiently).
The main way to skirt the limitations is to ensure you have the tables broke down to base components of a relational database. Check for redundent information that can be eliminated through relationships. If you do this and still find the size overwhelming, and cannot delete/export data thats no longer used, then I would suggest creating a seperate database for the various tables, then creating another to house the GIU, Queries, Macros, and Modules. Link the latter database to the other databases tables, and the size restrictions are now a little harder to reach. I highly suggest looking into a more robust database system if you catch youself doing this type of thing too often.

 

[The_Doc_Man]

In AC97 the topic is "Limits"

In AC2K the topic is "Specifications"

In either case, the Help files are the best places to look.