Problem with RefreshLink (FE/BE)

[Karl]

I have front end that links to table in a back end. The BE may be moved at
some point so I tried to set up a form where users could update the Link in
the FE. However when I try to refresh the link I get the following error.

Could not find installable ISAM.

the code is

Dim dbs As DAO.Database, tdf As DAO.TableDef
Dim NewConnection As String

Set dbs = CurrentDb
Set tdf = dbs.TableDefs("tSavedLines")

NewConnection = "DATABASE=" & iLink (ilLink is the full path to and
name of the BE mdb file)
tdf.Connect = NewConnection
tdf.RefreshLink

[storrboy]

On Feb 2, 3:35 pm, "Karl" <[e-mail]:

I have front end that links to table in a back end. The BE may be moved at
some point so I tried to set up a form where users could update the Link in
the FE. However when I try to refresh the link I get the following error.

Could not find installable ISAM.

the code is

Dim dbs As DAO.Database, tdf As DAO.TableDef
Dim NewConnection As String

Set dbs = CurrentDb
Set tdf = dbs.TableDefs("tSavedLines")

NewConnection = "DATABASE=" & iLink (ilLink is the full path to and
name of the BE mdb file)
tdf.Connect = NewConnection
tdf.RefreshLink

Start by adding a semi-colon ";" before DATABASE= example
(";DATABASE=...")
If not, try searching the group for the error message and see if there
are other cases similar to yours with solutions.