Linked table manager oddity (1 Viewer)

kevlray

Registered User.
Local time
Today, 13:01
Joined
Apr 5, 2010
Messages
1,046
So we are now on Office 365 and I need to link one of the tables to another database (test). But I go through the procedure. Create a new link. Id the table I want, click on re-line. But when I check the table's link data, it has not changed. Any ideas?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:01
Joined
Aug 30, 2003
Messages
36,118
Did you click the checkbox for "Always prompt for new location"?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:01
Joined
Oct 29, 2018
Messages
21,358
Can you post some screenshots showing the before and after relink?
 

kevlray

Registered User.
Local time
Today, 13:01
Joined
Apr 5, 2010
Messages
1,046
I think I figured out what is going on. It added a dbo. to the name of the table (my original table does not have the dbo.), So I will have to figure how how to fix that.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:01
Joined
Oct 29, 2018
Messages
21,358
I think I figured out what is going on. It added a dbo. to the name of the table (my original table does not have the dbo.), So I will have to figure how how to fix that.
Would renaming it work?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:01
Joined
Aug 30, 2003
Messages
36,118
dbo_ is typically added when linking SQL Server tables. Easy to delete if you're linking a table or 2, easy code to loop TableDefs if you're linking a bunch.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 16:01
Joined
Feb 19, 2002
Messages
42,973
The upsizing wizard automatically removed the dbo_ prefix. As the others have mentioned, when you link yourself, you need to also rename the linked table to remove the prefix.
 

kevlray

Registered User.
Local time
Today, 13:01
Joined
Apr 5, 2010
Messages
1,046
I just deleted the original table and re-named the 'new' table. All is good now. Thanks for the advice.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:01
Joined
Aug 30, 2003
Messages
36,118
Glad you got it sorted out.
 

Users who are viewing this thread

Top Bottom