File size

[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

 

[Cheryl Fischer]

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,