Web Development

Ask something
Discussion Locked

VB6 to Access 2000 problem

0 helpful
7 replies

by jmanson10

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

7 replies

by don christner

From with VB6, select Project|Referances scan down the list and make sure that you have MS Access XX.X Library selected (where the XX.X represents the library version). I am running WinXP and Office XP, so my library is version 10, yours will mostlikely be version 8.

Don

by jmanson10

Don, thanks for the attempt.
I tried this (my library is version 9), and still get the same error. If it helps, I also have:
Visual Basic For Applications,
Visual Basic runtime objects and procedures,
Visual Basic objects and procedures,
OLE Automation, and
Microsoft DAO 3.6 Object selected.

Jeff

by miss kitty

Try using ADO - here's an example:

Dim objConn As New ADODB.Connection
Dim objCmd As New ADODB.Command
Dim objRS As New ADODB.Recordset
Dim objParam As ADODB.Parameter
Dim count As Integer

'set up the database pointer
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=E:\ACCESS\CONTRACT HAULERS\HAULER.mdb;User ID=ADMIN"
objRS.CursorType = adOpenDynamic
objRS.LockType = adLockOptimistic

'setting the Active Connection for the command object
objCmd.ActiveConnection = objConn

If you still get the ISAM error, you may need to reinstall your Access. I had several users with the same error and had to reinstall their Access and it did take care of it.

Cathy

by nk196974

Reinstall Access and make sure you have selected
data access component.
Basically it is about msrd2x35.dll ,msrd2x40.dll.
But it is not only copying and registering
those dlls. there are other entries in the
registry for isam drivers
under local_machine\Microsoft\Jet
If you one working machine then insted of
reinstalling access you can copy all registry
setting under microsoft\jet from working
computer to non working computer
and also copy and register above dlls
if non working computer don't have those
files.

This discussion is closed to new replies.