Access Database size limitations

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

 

[Lisa]

Sorry, I'm new at this.....could you explain Front-
end/Back-end arrangement?

 

[Lisa]

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)

 

[Reno]

Does the 2gb limitation apply to access "97" also?

 

[Van T. Dinh]

Versions previous to A97 have even smaller limits. IIRC, Access1.0 had a
lmit of 128 MB.

HTH
Van T. Dinh
MVP (Access)