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]

Re: Problem with RefreshLink (FE/BE)

On Feb 2, 3:35 pm, "Karl" <some...@sbcglo bal.bizwrote:

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.