Access: Restablish a Linked Table

[gheyman]

At work I have a database that has one Linked table (and several others that are not linked).

I wanted to work on the database at home, so I had to brake the Link to the one table. (I did not change anything in the table I am refereeing to. I made changes to forms....)

Now I need to make that table Linked again. Is there an easy way to do this.

 

[Micron]

Re: Access: Restablish a Lnked Table

If you can put the link paths in a table, I can find some code for relinking. You'd need something to tell code which link to use, such as maybe a form prompt or more complex, getting the pc name at open. With the form prompt, you wouldn't have to worry about breaking code should you get a new pc at home or work. As long as db opening is "suspended" while inputting the value you shouldn't get any error about links.

 

[xenou]

Re: Access: Restablish a Lnked Table

There used to be a table manager in MSAccess for linked tables. You should be able to use that (assuming it still exists).

 

[Micron]

Re: Access: Restablish a Lnked Table

I took it that some sort of automated process was wanted since if OP had to relink to use at home, he already knew how.