How to solve the problem "unrecognised database format \database.mbd"
Hai friends,
I want to bring database.mbd in VB6. I have updated DAO6.0, loaded Data form wizard and data object wizard. I have already loaded latest service pack 6. Please let me know what more I have to do.
[226 byte] By [
krishnaxyz] at [2007-11-11 8:48:10]
# 1 Re: How to solve the problem "unrecognised database format \database.mbd"
It really depends upon what is generating the error. I would check with the following MS KB article:
PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or 2002 ( http://support.microsoft.com/kb/q238401/)
# 3 Re: How to solve the problem "unrecognised database format \database.mbd"
First step is to add the Microsoft DAO 3.6 Object Library reference to your project. After that the following code should work:
Dim db As DAO.Database
Dim rs As DAO.Recordset
'Open database using default Workspace
Set db = DBEngine.Workspaces(0).OpenDatabase("d:\My Documents\db1.mdb")
'Open table type Recordset
Set rs = db.OpenRecordset("Table1", dbOpenTable)
