Could not find installable ISAM. (Error 3170)

[Rod Behr]

The following code attempts to link a table:

Set QuoteDb = CurrentDb
Set td = CurrentDb.CreateTableDef("QuoteProductsHolding")
td.Connect = "DSN=TheFactory;DATABASE=TheFactory;Uid=Factory;Pwd=1mpact"
td.SourceTableName = "QuoteProductsHolding"
QuoteDb.TableDefs.Append td

On the last line I get error, "Could not find installable ISAM. (Error 3170)".

This seems to indicate a missing .dll file or incorrect registry reference
to a .dll file. I have uninstalled and re-installed Access without any joy.

Ideas?

 

[Jeanette Cunningham]

Rod,
have a look at this article on the microsoft site

http://support.microsoft.com/kb/209805/en-us


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Brendan Reynolds]

The following code attempts to link a table:

Set QuoteDb = CurrentDb
Set td = CurrentDb.CreateTableDef("QuoteProductsHolding")
td.Connect =
"DSN=TheFactory;DATABASE=TheFactory;Uid=Factory;Pwd=1mpact"
td.SourceTableName = "QuoteProductsHolding"
QuoteDb.TableDefs.Append td

On the last line I get error, "Could not find installable ISAM. (Error
3170)".

This seems to indicate a missing .dll file or incorrect registry reference
to a .dll file. I have uninstalled and re-installed Access without any
joy.

Ideas?

While the problem *may* be a missing or incorrectly registered DLL, that
error message is also sometimes caused by an error in the connection string,
so I would double-check that before assuming that there really is a driver
problem.