File size

  • Thread starter Thread starter Allen Wright
  • Start date Start date
A

Allen Wright

Hi!!
I've heard it said that the dumbest question it the
one you never ask. I think this question may push the
boundry!!

"Is there a size limit to the size of file that can
be created when adding data? I've a DB which is now 2.1
gigabytes and started getting "Invalid Argument", When
entering additional data into the table. Up to this point
it has been fine"
Thank you
Allen Wright
 
The maximum file size for an Access 2000 or 2002 database is 2 GB (Access 97
is 1GB). Some things you can do:

1. Open a new database and copy all of your objects from the existing
database. This will have the effect of reducing file size somewhat.

2. If your database is not split; i.e., data tables in one file (Back-End)
and queries, forms, reports, modules and macros in another (Front-End),
create a new database and import all of the tables into it. Once you have
verified that you have a good copy of these tables in the Back-End, delete
the tables from the Front-End and run a compact/repair on it. Then, from
the Front-End (now containing only queries, forms, reports, modules and
macros), use File|Get External Data|Link to link to tables in the other
database.

3. If your database is already split into a Front-End/Back-End scheme, you
can create an additional Back-End database and move some tables from the
original Back-End into it.

hth,
 
Back
Top