Refreshlink

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

Hi All,

I have a single Access 2000 front end and multiple Access
2000 backends all with an identical structure. There are a
couple of tables in the front end that are not linked
tables but occur only in the front end. I want to be able
to link to a chosen back end when the application starts.
I am using the following bit of code.

For Each tbl In CurrentDb().TableDefs
If (tbl.Connect <> "") Then
tbl.Connect = strPath
End If
tbl.RefreshLink
Next

I keep getting the following error " Could not find
installable ISAM". The proposed solutions I have found so
far suggest editing the windows registry. Are there any
other suggestions as this is not something I am familiar
with.

Many Thanks,

Ant
 
Back
Top