Create "Real" Copy of Linked Table

[MDW]

Hey all

I'm using Access with some tables linked to a SQL server db. For the most part, I've no problem with the linked table. However, at certain intervals (say, quarterly), I'm going to "publish" this database into a public network folder so that people can make use of the reports. I don't know if everyone would have the same setup on their PC as mine, such that they might not have the SQL Server drivers or whatever is needed for the links to function properly

(Not to mention the fact that I don't want the general populace to have a pipeline into the main SQL server.

What is the easiest way to take a linked table and make a "real" copy of it, one that would behave just like I'd created it natively within Access?

 

[Bas Cost Budde]

Hey all,

I'm using Access with some tables linked to a SQL server db. For the most part, I've no problem with the linked table. However, at certain intervals (say, quarterly), I'm going to "publish" this database into a public network folder so that people can make use of the reports. I don't know if everyone would have the same setup on their PC as mine, such that they might not have the SQL Server drivers or whatever is needed for the links to function properly.

(Not to mention the fact that I don't want the general populace to have a pipeline into the main SQL server.)

What is the easiest way to take a linked table and make a "real" copy of it, one that would behave just like I'd created it natively within Access?

Link it with a slightly different name (such as with suffix _L) and then
use a maketable query with that as source and the original name as
(local) destination

 

[Bas Cost Budde]

"freaks" (mainly Object Oriented Programmers, like me ;-) )
sometimes refer to such a copy as 'deep'. And indeed, to create a
complete copy of the table, you have to dig a little deeper.