access and linked tables 1

[iamapollo]

I have split the tables in a database i am designing between data and code. What I want to know is how do you relink the tables in code if the client moves the data part of the database, or it is installed in a different location than what I was designing in. I would like a routine to do the job then have to explain to the user how to manually relink the tables.

Thanks in advance

Michael Fabiankovits

 

[B827]

You could try something along these lines, you'll have to put in your own error handling - particularly for when the string entered is not correct. Or you might want to use the common dialog to find the source database name. This seems to work well in Access 97

Function ChangeTableSource(OldDB As String, NewDb As String)
Dim MyDb As Database, i As Integer
Set MyDb = CurrentDb
For i = 1 To MyDb.TableDefs.Count - 1
If MyDb.TableDefs(i).Connect = ";DATABASE=" & OldDB Then
MyDb.TableDefs(i).Connect = ";DATABASE=" & NewDb
MyDb.TableDefs(i).RefreshLink
End If
Next
End Function


Sandy

 

[lhuegele]

There is a "linked table manager" under Tools, Add-ins that is very easy to use to manage your linked tables. If your linked tables move, use this manager to easily fix all of your links.

Good luck,
Larry

 

[iamapollo]

Thanks Sandy

Does help simplify things, I just had no idea where to start, now it looks quite simple.

Thanks Again
Michael