database size

  • Thread starter Thread starter Joan Poythress
  • Start date Start date
J

Joan Poythress

I have setup a database that has multiple tables for
information on clients. The database also has numerous
queries, forms, and reports.

Is there a size limit for the overall database or for the
number of records Access can manage before I have to worry
about it?

I am using Access 2000. The database is stored on the
server. I have 4 users running Access 2000 on their
desktop machines using the database at the same time.
 
I have setup a database that has multiple tables for
information on clients. The database also has numerous
queries, forms, and reports.

Is there a size limit for the overall database or for the
number of records Access can manage before I have to worry
about it?
Click to expand...

2 GByte; no explicit limit on the number of records.
I am using Access 2000. The database is stored on the
server. I have 4 users running Access 2000 on their
desktop machines using the database at the same time.
Click to expand...

I'd VERY strongly recommend using the "Database Splitter Wizard" to
split the database into a backend (tables only, on the server) and a
frontend (forms, reports, etc., a copy on each user's machine). You'll
have far less trouble with corruption and conflicts between users.

Be sure to regularly Compact the backend (or the entire database if
you don't split).
 
Back
Top