We help IT Professionals succeed at work.

Access Linked table that I can't see

Murray Brown
Murray Brown asked
on
Hi

I have a split database Access solution for which I have code that automatically links the front end to the backend. When I run this code I am getting the following error. I do not have a link for the table mentioned. I never created such a table

Thanks

1
Comment
Watch Question

View Solutions Only

Commented:
temp table create by Access.

Probably don't need to worry about it but to be safe
take a copy of your database
and then run a compact and repair.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
Tables starting with '~' and 'MSys' are system tables and should be left alone.  Don't mess with them.  Setup your code to jump over (ignore) such tables.

Just like 'f_' tables are used for MVF and shouldn't be messed around with either.
John TsioumprisSoftware & Systems Engineer
Distinguished Expert 2019
Commented:
There is a chance you have some corrupted entry...the fast way would be to create a blank database and import everything.
Probably if you investigate the Msys table you should find the entry
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thank you all for the useful advice