Run-Time error 3110 on first Export

[MwaltmanFEI]

error on read definitions for unknown table or query. has anyone else experienced this? I attempted to turn off fast save option and still receive same error during table export step. Any help is appreciated!

[joyfullservice]

Hmm... I have not seen that before. Which version of Access are you using, and do you have any special permissions/security on the database that would affect the ability to read objects? You might also try a Compact/Repair after making a backup of the database. You could possibly be encountering some issues in the database unrelated to the add-in.

Let us know how it goes!

[MwaltmanFEI]

Hi I'm using Version 2406 Build 17726.20160. I am using mostly SQL linked tables but do have a few Access tables in play as well. I've tried compact and repair with no change. The names of the "tables or queries" listed in the error are not familiar and I'm not able to locate them. Not unusual for Access to provide vague information on the error dialog though :).

[Tanarri]

Hi,
I don't have seen such an error. But I had earlier such named queries, which begins with "~".
These were tmp-objects from access, I did delete it without side effects.

[MwaltmanFEI]

@Tanarri Thanks! I agree the "~" indicates a temp object but I've been unable to find the temp objects to delete. Any guidance on how you did it?

[mwolfe02]

Those queries with the leading tilde (~) typically represent literal SQL statements stored in the RecordSource properties of forms/reports or the RowSource properties of Combo/List box controls. If you can identify the form or report where they are coming from, you may be able to do a SaveAsText/delete object/LoadFromText cycle on the object to clear out the query from whatever internal location it is being stored.