General discussion

Locked

VB6 to Access 2000 problem

By jmanson10 ·
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 conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

VB6 to Access 2000 problem

by Don Christner In reply to VB6 to Access 2000 proble ...

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

Collapse -

VB6 to Access 2000 problem

by jmanson10 In reply to VB6 to Access 2000 proble ...

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

Collapse -

VB6 to Access 2000 problem

by Miss Kitty In reply to VB6 to Access 2000 proble ...

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

Collapse -

VB6 to Access 2000 problem

by jmanson10 In reply to VB6 to Access 2000 proble ...

Poster rated this answer

Collapse -

VB6 to Access 2000 problem

by nk196974 In reply to VB6 to Access 2000 proble ...

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.

Collapse -

VB6 to Access 2000 problem

by jmanson10 In reply to VB6 to Access 2000 proble ...

Poster rated this answer

Collapse -

VB6 to Access 2000 problem

by jmanson10 In reply to VB6 to Access 2000 proble ...

This question was closed by the author

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums