Convert SQL linked Tables to Local Tables (1 Viewer)

vagues0ul

Registered User.
Local time
Today, 11:16
Joined
Sep 13, 2018
Messages
103
I have a database on which i am using linked tables that i have created with SQL server 2008. Now i want to deploy the application to another pc and wanted to convert all the linked tables to local table. I tried converting them to local tables by Right Clicking on them. But after that when i open form, it asks for reference of each element (Txtbox, CBO, Macro, Calculated field).

How to properly convert the linked tables to local so that i wont effect all the present form created with those tables. Thanks
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:16
Joined
May 7, 2009
Messages
19,169
use Make table query.
then delete the linked table.
rename the new tables with 'dbo_' as prefix.
 
Last edited:

isladogs

MVP / VIP
Local time
Today, 18:16
Joined
Jan 14, 2017
Messages
18,186
Or temporarily turn on Name Auto Correct.
Rename each linked table removing the dbo_ prefix.
Check the forms etc now work correctly.

Right click and convert to local table
Switch off name auto correct

BTW if you use DNS-less connection strings, you can alias each table so it doesn't have dbo_ prefix.
As a result the right click convert option works without any issues whatsoever
 

Users who are viewing this thread

Top Bottom