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

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
 

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

refreshing or relinking tables by code 2
Could not find installable ISAM. (Error 3170) 2
Relinking Tables Programmatically 2
Could Not Find Installable ISAM 2
Change drive letter in linked table manager 5
Change one table link by vba 1
Error "could not find installable ISAM" 6
ADO error "could not find installable ISAM" 2

Top