VB6 to Access 2000 problem - TechRepublic
General discussion
April 9, 2003 at 01:31 AM
jmanson10

VB6 to Access 2000 problem

by jmanson10 . Updated 23 years, 2 months ago

I am trying to access an Access 2000 (SR-1) Database via a Visual Basic 6 (SP5) program.
I attempt to access it as follows:

Dim dbMember As Database
Set dbMember = DBEngine.Workspaces(0).OpenDatabase(“the database.mdb”, False, False, “Access 2000”)

I get the following error on the Set statement:
Runtime error ‘3170’.
Couldn’t find installable ISAM.

Can anybody tell me which DLL is missing and how I can find and install it?

This discussion is locked

All Comments