database size

[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.

 

[Lynn Trapp]

The only limitation is that the size of the file cannot exceed 2 gigabytes.

 

[John Vinson]

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?

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.

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).