increasing capacity of Access

[Paulg]

Any ideas on increasing the capacity of Access. I have a
database of about 125,000 records, with 25 fields each.
Forms and querys related to the records as well. I have
already compacted several times. Querys won't run.

Paul G

 

[Cheryl Fischer]

Paul,

The maximum size of an MDB file in Access 97 is 1 GB; in Access 2000 and
newer, it is 2 GB.

The first thing I'd suggest to you is that you split your database into two
MDB files: A Front-End containing all Queries, Forms, Reports, Macros and
Modules and a Back-End containing all shared tables. Use the File|Get
External Data|Link in the Front-End to link tables from the Back-End.

If this does not resolve the problem you report (queries do not run), please
post back with more details about the queries and the exact error messages
you may be receiving.

 

[John Vinson]

Any ideas on increasing the capacity of Access. I have a
database of about 125,000 records, with 25 fields each.
Forms and querys related to the records as well. I have
already compacted several times. Querys won't run.

Paul G

That's not a particularly huge table - I'm aware of Access databases
with 20,000,000 row tables. How big is the .mdb file, in megabytes?
What "doesn't run"? What are the symptoms? Do you have just the one
table? How about queries, forms, reports?