Linked table manager oddity

[kevlray]

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]

Did you click the checkbox for "Always prompt for new location"?

 

[theDBguy]

Can you post some screenshots showing the before and after relink?

 

[kevlray]

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 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]

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.

 

[kevlray]

I just deleted the original table and re-named the 'new' table. All is good now. Thanks for the advice.

 

[pbaldy]

Glad you got it sorted out.