Problem with Compacting

[jpaokx]

Hi,

I have an Access file which is around 1.2GB of size.
The version that I am using is 2010 Access.

I have a database that I imported it from a csv file with no issues. Once I simply run an update query or any query that modifies the data and, then, try to compact/repair the whole file, then I get the following error:
"The Microsoft Access database engine could not find the object ''. Make sure the object exists and that you spell its name and the path name correctly. If '' is not a local object, check your network connection or contact the server administrator".

The file is in my local drive, the filename and path name are short and I, honestly, don't have any idea why this is happening. Eventually, I cannot reduce the size of the file and, consequently, this is becoming bigger in size.

Has anyone experienced a similar issue? Any solution for this?

Thanks!

 

[Ranman256]

have you tried, open access, but NO database.
run the compact , pick your source file, type in the Save As file
does this work?

 

[The_Doc_Man]

jpaokx, forgive me for asking the question this way, but sometimes newly registered users are also new to Access itself and thus might be imprecise with nomenclature.

When you say you imported the file from a .CSV, my question (based on the error message you quoted) is whether you really imported the file to a table inside Access or did you build an external link to a CSV file, which in Access ALSO looks like a table - but is harder to manipulate?

 

[boerbende]

Sounds to me that your database is somewhat corrupt
You can try to import everything in a fresh database
open a new database
use external data, import access database and import all your items from the "defect database".

 

[Rx_]

Let me try to help. This saved a database for me more than once.
Copy (don't open) your existing Access DB onto your local C:\ drive in some folder.

Open a new Blank Access Database. It will try to open an example empty table. Delete that table. Then use Save Database As - be sure to save it on your local C:\ drive in some folder where it can be located.
In the new blank database, click File menu then - Compact and Repair.

In the new blank database, go to the menu External Data
Choose Access. A dialogue box will appear.
In the File Name - locate the Access DB in the first step (the broken Access DB)

Choose import Tables, Queires, Forms, .... option button. Note, the external Access DB should not be open and running.
The wizard will guide the next steps. Be sure to import every object under all categories.

End the import and go back to File and Compact and Repair.
Now, open your new Access DB - on one screen and the old Access DB on your 2nd screen side by side.

Open both of them using File - Options (see Access Options with General, Current Database, Datasheet and the rest)
Go through each Access Option - type the old Access values into your new version.

Sometimes, the code compiler works in the old one. Then, suddenly it finds issues in the new one. this Import process will solve many problems.

Good Luck