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