Sorry about the multiple posting but the original post was not
appearing in the newsgroups from my pc even a few days after my
original post, therefore I posted it again.
I have a 2Gb access database with a number of tables (50+) and I
wondered if their was any easy way of identifying the largest table in
database to possibly move to another database.
I have a 2Gb access database with a number of tables (50+) and I
wondered if their was any easy way of identifying the largest table in
database to possibly move to another database.
What version of Access? and... do you have any Pictures stored in any of these
tables? Versions of Access prior to the latest (2007) handle graphic images
VERY inefficiently, and even a few pictures can bloat a database to enormous
size.
If it's *over* 2GByte it may be corrupt and may not let you compact. Can you
create a new database and Import tables? How many rows in the largest table?
You may well be exceeding what Access can handle: have you considered using
Access as a frontend to a client/server database such as SQL/Server?
John W. Vinson [MVP]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.