Access Error

S

Sumeth

Hi,
My access database's size is 2 GB. I can't edit any field of them it
show error all the time whenever I change the data. The error show " Invalid
argument " .
The file can work correctly before. My Partition C: is NTFS.

Any could help me pls.,
Thank you.
 
A

Anthos

It might be time to perform a compact and repair on the database and /
or look at either spliting the database with an MS Access front /
backend or a SQL server backend.
 
D

Dale Fye

Here is what I would do:

1. Make a backup copy of the database
2. Create a new, empty database, and Import all of your objects (tables,
forms, modules, macros, queries, into it). Don't forget your custom menus
and import specifications if you have them. This will clean up any
extraneous objects that are no longer being used in the database
3. Compact this new database
4. Split the database into frontend/backend
5. If the backend is still close to the 2GB limit, then it is time for you
to consider moving your data to SQL Server.

HTH
Dale
 
Top