Error: 3170 Could Not Find Installable ISAM 1

[DISI]

A friend is trying to run an application I wrote in Access '97. It runs fine on other PC's but he gets "Error: 3170 Could Not Find Installable ISAM" when (I believe) this piece of code runs

DoCmd.TransferText acExportDelim, , _
"TblAgree", "C:\cholesterol provider report\Agreed.txt"

We have Reinstalled, uninstalled, installed again. We have gone to MS Knowledgebase and tried running Regsvr32.exe. We have re-installed Access 97 after renaming Setup.stf. We have re-run SR2a patch and installed Dataacc.exe

I am at a complete loss and need some help please.

Thanks in advance. Paul Faculjak
paul@DataIntegritySolutions.com

 

[DougP]

You are using a database connection to something that the other machine does not have.

He does not have the ISAM to export the text file.

Did you install "ALL" options on his machine???
There is a list of these in your \system32 folder, though I' don't remeber where.

Installing the latest MDAC "Microsoft Data Access Control" (formerly ODBC) may fix the problem.
Get the lastest ODBC drivers "MDAC 2.6" from Microsoft

http://www.microsoft.com/data/download.htm

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[DISI]

I'll give the MDAC 2.6 drive update a try. We have already done full installs will ALL the options. Which MDAC 2.6 download do I want: MDAC 2.6 SP1 or MDAC 2.6 RTM?

We loaded the application on a PC and it worked, but we really need it on the laptop so I'm going to continue problem solving. I'll wait for your reply. Many thanks.

Paul Paul Faculjak
paul@DataIntegritySolutions.com

 

[PeterGillham]

Check this error in the MS Knowledge base but basically an easy way round is to re-install MS office in a directory with a shorter path eg C:\Office.

It is a pain 'cos I've crossed it several times now !

 

[genomon]

The only time I ever got this error and it was EASY to fix was while executing the following connection string from a VB6 app: cnWW.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=C:\MyTemp\WW.mdb"
It turned out that I had originally omitted the space between "Data" and "Source"! Might be worth double checking the syntax one more time....

 

[Databaseguy]

That error happens when you don't have support for all file types installed.

Go to the Office 97 install disks. In the ValuePack/DataAccess directory, run dataacc.exe Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy