I created a database in Access 2000. I tried to use the following code in VB 6.0 to open that database:
---
Dim wspDefault As Workspace
Dim DB As Database, DBSet As Recordset
' Grab the default workspace.
Set wspDefault = DBEngine.Workspaces(0)
' Open the database.
Set DB = wspDefault.OpenDatabase("c:\temp\xxx.mdb"
---
When I run it, though, it gives me error 3343: "Unrecognized database format".
Is this because VB does not have / know the correct Jet DLLs to access a database created in Access 2000? They must exist otherwise how is Access doing it... If this is the problem, how / where do I get the right files, and where do I put them? If not, what have I done wrong?
---
Dim wspDefault As Workspace
Dim DB As Database, DBSet As Recordset
' Grab the default workspace.
Set wspDefault = DBEngine.Workspaces(0)
' Open the database.
Set DB = wspDefault.OpenDatabase("c:\temp\xxx.mdb"
---
When I run it, though, it gives me error 3343: "Unrecognized database format".
Is this because VB does not have / know the correct Jet DLLs to access a database created in Access 2000? They must exist otherwise how is Access doing it... If this is the problem, how / where do I get the right files, and where do I put them? If not, what have I done wrong?