search

joyfullservice / msaccess-vcs-addin

Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
Other
203 stars 39 forks source link

Run-Time error 3110 on first Export #523

Open MwaltmanFEI opened 1 month ago

MwaltmanFEI commented 1 month ago

image

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 commented 1 month ago

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 commented 1 month ago

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 commented 1 month ago

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 commented 1 month ago

@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 commented 1 month ago

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.