Accessing other databases in access

[techie jamal]

I have a user who has reached the size of almost 3 gigs in here mdb so it
won't let her import anymore tables. The db is used to look at statistics
monthly but then compare it to the previous months results that are in the db
already. I have gone to a new db and I am able to import the tables into this
new db so it seems like it is the size of the original db. Is there a way for
the user to create a new mdb but pull information from the original db inot
it for the comparison?

 

[Noëlla Gabriël]

Try linking the tables in stead of importing them.

 

[John W. Vinson]

I have a user who has reached the size of almost 3 gigs in here mdb so it
won't let her import anymore tables.

Since the limit is 2GByte I'm surprised she got that far! Has this database
been Compacted???

The db is used to look at statistics
monthly but then compare it to the previous months results that are in the db
already. I have gone to a new db and I am able to import the tables into this
new db so it seems like it is the size of the original db. Is there a way for
the user to create a new mdb but pull information from the original db inot
it for the comparison?

You can link to tables instead of importing them (though performance on
cross-database joins may be a problem). How many rows of data are in a typical
month? If you just create a database with one month's data, and compact it,
how big is that database? Should this user perhaps be using SQL/Server or SAS
or SysStat instead of Access?