error 3170 could not find installable ISAM

R

Rod

I have a split database with the front end linking to several tables.
Compiles and runs perfect in Windows XP, whatever SP, Access 2002 and 2003.

I have a new computer with Windows Vista Business. I receive the following
error in Access 2003 and 2007:

"Run-time error 3170: Could not find installable ISAM."

The code stops at a point when trying to relink to a table, using the
following code:

Function RelinkToSpringfieldCountriesA() As Integer
Dim dbs As DAO.Database
Dim tdf As DAO.TableDef
Dim FilePath As Variant

Set dbs = CurrentDb
Set FilePath = Forms!frmControlSMP.txtSMPDataPathWithFile

Set tdf = dbs.TableDefs("SpringfieldCountries")
tdf.Connect = ";DATABASE=" & FilePath
tdf.RefreshLink

End Function

The specific point is tdf.RefreshLink.

I'm stuck.

Rod
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba error 3170: Could not find installable ISAM 11
Could not find installable ISAM. (Error 3170) 2
refreshing or relinking tables by code 2
Relinking Tables Programmatically 2
Error 3170: Couldn't find installable ISAM 1
Change drive letter in linked table manager 5
Error "could not find installable ISAM" 7
link all tables but one using VBA 1

Top