By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Max Size of an Access DB?

P: n/a
Are there ny guidelines for using space usage with ASP/Access?

I have an Access 2000 DB on shared Web space, which is 2MB but
growing, and soon to reach about 10MB due to a catalog change. My host
places a normal limit of 10MB before an upgrade is needed to more
space. Now I have no response issues, but I am planning.

Currently about 400 users a day visit, but this should increase as the
the catalog grows (now 14 lines, set to go to 100). Visitors use the
catalog for price checks, shopping cart, and online ordering uses the
same DB (no CC are held).

I am wondering if a space/memory guideline exists for using Access,
and when an upgrade to SQL Server 2000 is needed.

Can anyone shine light on this topic?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Well, Access97 had a 1GB limit so I think you're safe. Your number of users
in a day is irrelevant... number of simultaneous users is the important
thing.

D.
"Trevor" <sa***@logicians.com> wrote in message
news:88**************************@posting.google.c om...
Are there ny guidelines for using space usage with ASP/Access?

I have an Access 2000 DB on shared Web space, which is 2MB but
growing, and soon to reach about 10MB due to a catalog change. My host
places a normal limit of 10MB before an upgrade is needed to more
space. Now I have no response issues, but I am planning.

Currently about 400 users a day visit, but this should increase as the
the catalog grows (now 14 lines, set to go to 100). Visitors use the
catalog for price checks, shopping cart, and online ordering uses the
same DB (no CC are held).

I am wondering if a space/memory guideline exists for using Access,
and when an upgrade to SQL Server 2000 is needed.

Can anyone shine light on this topic?

Nov 12 '05 #2

P: n/a
The Jet database engine that comes with Access 2000 and later versions has a
maximum size of 2GB, but you can use larger amounts of data by using
multiple databases with linked tables. Size alone is rarely, if ever, a
valid reason for moving from a Jet (aka Access) database to a server
database.

Jet databases tend to grow as they are used, because space vacated by
deleted records, deleted database objects, and internally created workspace
is not recovered until the database is Compacted. So, you may be able to
shrink your database substantially simply by opening Access, and on the
database window, Tools | Database Utilities | Compact and Repair.

The same limit applies to the Microsoft Database Engine (MSDE) aka Microsoft
SQL Server Desktop that comes free with Access, but must be installed
separately.

Larry Linson
Microsoft Access MVP
"Trevor" <sa***@logicians.com> wrote in message
news:88**************************@posting.google.c om...
Are there ny guidelines for using space usage with ASP/Access?

I have an Access 2000 DB on shared Web space, which is 2MB but
growing, and soon to reach about 10MB due to a catalog change. My host
places a normal limit of 10MB before an upgrade is needed to more
space. Now I have no response issues, but I am planning.

Currently about 400 users a day visit, but this should increase as the
the catalog grows (now 14 lines, set to go to 100). Visitors use the
catalog for price checks, shopping cart, and online ordering uses the
same DB (no CC are held).

I am wondering if a space/memory guideline exists for using Access,
and when an upgrade to SQL Server 2000 is needed.

Can anyone shine light on this topic?

Nov 12 '05 #3

P: n/a
I should add... that's 1GB for a MDB. You can link to multiple MDBs.

D.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.