VBA run-time error 3170: Could not find installable ISAM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I posted the question below on the Access programming group with no response.
Can anyone help me install an ISAM or whater is necessary to run an Access
application on Vista?
.............

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