Can't disable source checking

[chrisleng]

Even with autocorrect disabled I still get Expr#: in all my queries when I import them, how can I stop this?

(there are 500 or so queries so must be a bulk method and many of them are based on temp tables created during running so getting all the source tables is not an option)

[June7]

Don't understand what you are doing. Not familiar with this issue. Importing from where?

[chrisleng]

just from an old possibly corrupt accdb to a new accdb

[June7]

Try a copy/paste of the query objects from old db to the new db. You would have to respond to 500 'Paste Query As' prompts. It does work, however, no idea what will happen if your db is corrupted. Do a test with one and see if the Expr# error still occurs. If this works, is it worth 5 minutes of your time for 500 clicks?

[chrisleng]

I think I've found another layer to the issue,

If I open the query in my main front end in design view it shows the same thing, the table shows in design view with just a * cos it doesn't exist, the fields show as "Expr1: [field].[table]"

When I close it it asks if I would like to save changes,

So it looks like its the source database that causes the issue, or both ends!

Any ideas for a workaround?

[June7]

This is a split design? The backend is an Access db?

Go to the backend and view tables directly, do they look fine?

Go to frontend - are table links established? Maybe refresh links with Linked Table Manager?