I'm not trying to link to linked tables.The only tables that will show in the dialogue that results from trying to link an Access table, while using the FE, are the Access tables in the back end. Not [any kind of] linked tables.
Have you tried using a different computer? Just curious...I copied them to a new database, same issue. I downloaded it from the client to my system which is running on 2016 same issues.
Those don't look like they are linked tables. Were they linked tables before? If you change the data in one of those tables, do you see the change in SQL Server?I'm not trying to link to linked tables.
In the backend there are no linked table. The Navigational Display will not show any tables unless the "Show System Tables" is checked.
Then it shows all the tables, they can be opened locally, but not linked. If you copy and past them to a new database, the same condition applies.
View attachment 85343
Good job!The client did a restore from last night.
It works.
No that is the actual "backend". In the backend the tables are displayed as System TablesThose don't look like they are linked tables. Were they linked tables before? If you change the data in one of those tables, do you see the change in SQL Server?
Thanks, it still leaves a huge mystery.Good job!
Okay, now I'm confused. I thought the backend was SQL Server. The only way I know how to convert/change a local table into a system table is through code. Do you know anyone using your db who could do that?No that is the actual "backend". In the backend the tables are displayed as System Tables
I do not. I will make a new one with a few non-proprietary tables if you want to see it.Okay, now I'm confused. I thought the backend was SQL Server. The only way I know how to convert/change a local table into a system table is through code. Do you know anyone using your db who could do that?
The only tables that will show in the dialogue that results from trying to link an Access table, while using the FE, are the Access tables in the back end. Not [any kind of] linked tables.
So what I mean is, if you have created linked (SQL Server) tables in the back-end, and you open the FE and try to use the Link tables dialogue to see what tables in the BE you can link to, you won't see any of those linked tables there.
They should simply be linked directly from the FE to SQL Server.
I have seen something like this a long time ago but can't remember what caused it or how I resolved it at the timeI do not. I will make a new one with a few non-proprietary tables if you want to see it.
SELECT MSysObjects.Name, MSysObjects.Type, MSysObjects.Flags
FROM MSysObjects
WHERE ((Not ((MSysObjects.Name) Like "MSys*" Or (MSysObjects.Name) Like "f_*")) AND ((MSysObjects.Type)=1) AND ((MSysObjects.Flags)<>0));
How is it misleading?I think this comment is somewhat misleading.
I felt it could give the impression to anyone reading this topic that users cannot link tables that are linked in another database.How is it misleading?
While you are correct in the distinction between what shows in Link vs. Import dialogue, the original post was concerning Linking. And, my comment specifically stated Linking too.