Access Database size limitations

  • Thread starter Thread starter Lisa Raimondo
  • Start date Start date
L

Lisa Raimondo

We are currently using Access 2000 and would like to know
if Access 2000 has any size limitations to its database
before it begins to act sluggish or become inoperable.
Users are on computers with 2.4Ghz Processors, 512MB RAM
with Windows98/2000, and 30-60GB hard drives.

Please advise. Thank you.
 
Access 2000 files size is limited to 2GB. Performance will depend on
application design, network considerations, etc.

Is the database split into Front-end/Back-end arrangement?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 
In a multi-user arrangement, the proper way to set Access up is to have two
databases: One with the tables located on a server that everyone can get
to, and the other database has all of the other objects (Forms, reports,
etc.). This second db has links to the other database (the one with the
tables), and a copy of it is on the hard drive of each user.

See also "Split an Access Database" in Access Help.

If you do not split the db in this manner, and everyone is using the same
file at the same time, you are asking for database corruption and data loss.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 
Thanks for the explanation. I would like to set it up for
multi-users and doing it the way you suggested. However,
before this happens, going back to my original question,
is 2GB the max size it can handle by doing this way?

Also, do you provide services in the NJ area for setting
up databases and training on how to use Access?

Lisa
(e-mail address removed)
 
2GB is a LOT of data. By using multiple back-ends you can get around this,
but when a database gets to be that size, I generally recommend to my
clients that they move to SQL Server.

Regarding the services I provide, I will send you an email offline so we
don't bore everyone else in the NG. :-)

Thanks,

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com
 
Versions previous to A97 have even smaller limits. IIRC, Access1.0 had a
lmit of 128 MB.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top