Could not find installable ISAM. (Error 3170)

  • Thread starter Thread starter Rod Behr
  • Start date Start date
R

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?
 
Rod Behr said:
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?
Click to expand...


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