ms access 2000 changing linked tables without using Linked table manager

Question

I'm using MS ACCESS 2000. I have few tables in AB.mdb linked to some other table XY.mdb in my machine. Its working fine in my machine local.

Now if i move this AB.mdb to some other machine its showing error as its is searching for XY.mdb in its local machine.

I cannot change path in that machine using linked table manager because we dont have access from that machine.

Is there any way to solve this issue.

any way to change path of linked tabels other than linked table manager

Thanks,

Shanmugam

score 2 · Accepted Answer · edited May 23 '17 at 11:47

2

You can change the linked tables target programmatically in VBA.

edited May 23 '17 at 11:47

Community

answered Jul 26 '11 at 07:06

Jacob

No problem, welcome to SO. Have a look at the [FAQ](http://stackoverflow.com/faq#howtoask) – Jacob Jul 26 '11 at 08:20
Thanks for your answer Cularis, But my issue is in AB.mdb only few tables should be changed using liked table programmatically. Solution you gave is like to change everything? is there any other way? – Shanmugam Jul 26 '11 at 08:31
1

You can alter the solution to only change some columns? – Jacob Jul 26 '11 at 08:33
Ya i tried Relink Tables in Code- third link which you have given. In that we are getting " Select a Data Source " box to select a table. But issue here is i cannot add that sever path to my network places i dont have acces.... but some how i have to use that in ms access application? – Shanmugam Jul 26 '11 at 08:47
I also have a reconnect utility that works with multiple back ends: http://dfenton.com/DFA/download/Access/Reconnect.html -- this is an Access FAQ, basically remedial Access and there are solutions for it all over the Internet. The most basic Google search should have produced working solutions within the first five links. – David-W-Fenton Jul 27 '11 at 00:39

1 Answers1