Could not find installable ISAM

[jpiscit1]

Ok. I am ready to pull my hair out on this one. I hope someone can help.

I am developing an MS Access 2000 DB as a front end for a SQL 2000 DB. I am attempting to use code to dynamically connect my SQL Tables. The problem is, when I run the code I get a "Could not find installable ISAM 3170 error".

Now, I have followed the instructions under Microsofts website here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209805

Including running the Office 2000 repair. I have re-registered the dll's as required. Im stuck!

My Access DB has a reference to Microsoft DAO 3.6 Object Library and I am using code taken from here

http://www.mvps.org/access/

to dynamically connect the databases.

Can anyone shed some light on what may be going on here ???

Thanks in advance.


Your limits are only as far as you set your boundries......

 

[Quehay]

jpiscit,

Post your connection code...SQL is typically much cleaner to get a connection with than Access BE's.

Also:

http://www.ableconsulting.com

http://www.connectionstrings.com

(If I didn't remember the URL's verbatim do a Google search on these titles--they are great connection string example pages.)


Jeff Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com