Access 2000 and "Unrecognized Database"

Access 2000 and "Unrecognized Database"

Post by Wayne Harri » Wed, 18 Aug 1999 04:00:00



There are at least 2 posts a day on Access 2000 and VB6 problems.  There are
multiple and various responses.  But, I have found this article:

Q232337 BUG: MFC Wizards Fail with "Unrecognized Database Format"

It is for Microsoft C++ 6.0, but it does say that there is a BUG in the
wizards and the only way to fix it is to go back to Access 97.  I would
assume that VB 6.0 would be in the same category.  Maybe Microsoft will get
around to fixing it.

wh

 
 
 

Access 2000 and "Unrecognized Database"

Post by Bill McCarth » Thu, 19 Aug 1999 04:00:00


I believe there is a problem using Access 2000 database with VB's intrinsic
data control.  From memory this is because the VB intrinsic data control
uses DAO3.5 and for Access 2000 you need to use DAO3.6,  so in VB you can
create your own data control using DAO3.6, or use the ADO control and
happily work with Access 2000 databases.


Quote:> There are at least 2 posts a day on Access 2000 and VB6 problems.  There
are
> multiple and various responses.  But, I have found this article:

> Q232337 BUG: MFC Wizards Fail with "Unrecognized Database Format"

> It is for Microsoft C++ 6.0, but it does say that there is a BUG in the
> wizards and the only way to fix it is to go back to Access 97.  I would
> assume that VB 6.0 would be in the same category.  Maybe Microsoft will
get
> around to fixing it.

> wh


 
 
 

Access 2000 and "Unrecognized Database"

Post by Ralph D. Col » Fri, 20 Aug 1999 04:00:00


The problem is that VB6 intrinsic controls and data objects default to 3.5
and you now need to use DAO 3.6 to access Access 2K, by specifically filling
in the 'DataSource'. The Wizards are broke because they also default to DAO
3.5.

Take a look at the following:

http://msdn.microsoft.com/library/devprods/vs6/vbasic/vbcon98/vbconin...
tactrlandaccess2000.htm

Oh, to make sure you have all the latest DLLs go ahead and download MSDAC
2.1 from http://www.microsoft.com/data and if you are using Win95 install
the DCOM95.

There is a Data Form Wizard fix, but I was unable to get it to work so I
can't recommend it at the moment till I find out what is wrong with my
downloaded code.

There is another ugly alternative to the Wizards. Export an Access 97 table
from Access 2K.  (data is unimportant). Use the Wizard to generate the code
from the 97 database, then go back in and change the references and
properties. Your app is now talking to Access 2K. (Hey, I said it was ugly!)

-ralph

--
-

Quote:> There are at least 2 posts a day on Access 2000 and VB6 problems.  There
are
> multiple and various responses.  But, I have found this article:

> Q232337 BUG: MFC Wizards Fail with "Unrecognized Database Format"

> It is for Microsoft C++ 6.0, but it does say that there is a BUG in the
> wizards and the only way to fix it is to go back to Access 97.  I would
> assume that VB 6.0 would be in the same category.  Maybe Microsoft will
get
> around to fixing it.

> wh

 
 
 

1. VB6 - Access 2000 - "Unrecognized Database Format"

I am getting "unrecognized database format" when attempting to use a data
control with Access 2000.

The MSDN article is pasted below. You still cannot assign the data control
RecordSource property or the data bound control DataField property without
getting the error.

And Sheridan controls don't seem to work at all. Is this fixed yet?
How/where do I get the fix?

Thanks,
jjjones

Intrinsic Data Control Is Usable with Access 2000 Databases

At design time, trying to bind the Data control to a Microsoft Access 2000
database will result in an error: "Unrecognized database format." The Data
control can still be used, however, by following the example below:
On the Project menu, click References. Clear the Microsoft DAO 3.51 Object
Library check box.

Set a reference to the Microsoft DAO 3.6 Object Library.

Draw a Data control and a TextBox control on a form.

On the Properties window, set the TextBox control's DataSource property to
the Data control.

Type the name of the field CompanyName into the DataField property box.

Insert code similar to the following into the code window:
Option Explicit
Private daoDB36 As Database
Private rs As Recordset
Dim sPath As String

Private Sub Form_Load()
    sPath = _
    "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
    Set daoDB36 = DBEngine.OpenDatabase(sPath)
    Set rs = daoDB36.OpenRecordset("Customers")
    Set Data1.Recordset = rs
End Sub

Run the project.

2. Cannot connect to Oracle 9i as SYS user

3. "Unrecognized Database Format": Access 2000 and VB6 Data Form Wizard

4. How to develop a simple database application? (Newbie)

5. "Unrecognized database format ..." - Access 2002

6. java.sql/Oracle.jdbc conflict.

7. err msg "unrecognized database format"

8. case statement and nested loops

9. "Unrecognized database format"

10. Error message "Unrecognized database format"

11. "Unrecognized database format"

12. "Unrecognized format error"