increasing capacity of Access

  • Thread starter Thread starter Paulg
  • Start date Start date
P

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
 
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.
 
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
Click to expand...

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?
 
Back
Top