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?