Hi all,

  I am trying to link a table in Biblio database from Visual Basic.
I converted the original Biblio.mdb to a newer version 
(Biblio_2000.mdb) so that I can use Access 2000 to work on it.

  But when I use the data control in Visual Basic to link 1 of the
table from Biblio_2000.mdb, it failed and prompted me a message,
as below:

  Unrecognized database format 'C:\Database\Begining Visual Basic 6 _
  \Biblio_2000.mdb

  Of course I can use the original version to work on, but I wonder
what is the way to overcome the problem with the new version of the
database.

  I appreciate if you can provide me any solution.

  Thank you.

Regards,
Mike Yeap

Mike,

For what it's worth, here is my recommendation.

1. Delete the current Biblio_2000.mdb
2. Create Biblio_97.mdb by copying Biblio.mdb to a new directory.  It 
will
retain Access '97 format.
3. Create a new Biblio_2K.mdb with all the tables as links to 
Biblio_97.mdb.
Biblio_2k.mdb can be converted to Access 2K format.

This way you can use Access 2K with Biblio_2K and VB with its older 
controls
(the source of the compatibility problem) can be used with Biblio_97.  
Then
both programs will be able to work with the same data.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Mike Yeap [mailto:wkk1020@g...]
Sent: Tuesday, May 28, 2002 11:09 AM
To: Access
Subject: [access] Unrecognized database format.

Hi all,

  I am trying to link a table in Biblio database from Visual Basic.
I converted the original Biblio.mdb to a newer version
(Biblio_2000.mdb) so that I can use Access 2000 to work on it.

  But when I use the data control in Visual Basic to link 1 of the
table from Biblio_2000.mdb, it failed and prompted me a message,
as below:

  Unrecognized database format 'C:\Database\Begining Visual Basic 6 _
  \Biblio_2000.mdb

  Of course I can use the original version to work on, but I wonder
what is the way to overcome the problem with the new version of the
database.

  I appreciate if you can provide me any solution.

  Thank you.

Regards,
Mike Yeap

On Tue, 28 May 2002 16:08:39 "Mike Yeap" wrote:

> Hi all,
> 
>   I am trying to link a table in Biblio database from Visual Basic.
> I converted the original Biblio.mdb to a newer version 
> (Biblio_2000.mdb) so that I can use Access 2000 to work on it.
> 
>   But when I use the data control in Visual Basic to link 1 of the
> table from Biblio_2000.mdb, it failed and prompted me a message,
> as below:
> 
>   Unrecognized database format 'C:\Database\Begining Visual Basic 6 _
>   \Biblio_2000.mdb

The most obvious explanation is that probably Biblio_2000.mdb was 
produced via a newer version of Access than the Access 2000 that 
you are using. I would assume that as usual there is no compatability 
that way, i.e. that Access XP can read an Access 2000 mdb but not the  
other way around.

Paul

Verify that in your VB (VB6 I presume?) References dialog that you have 
Microsoft DAO 3.6 Object Library checked.  Also check your "Connect" 
property of your DataControl.

R

> Hi all,

>   I am trying to link a table in Biblio database from Visual Basic.
I>  converted the original Biblio.mdb to a newer version 
(> Biblio_2000.mdb) so that I can use Access 2000 to work on it.

>   But when I use the data control in Visual Basic to link 1 of the
t> able from Biblio_2000.mdb, it failed and prompted me a message,
a> s below:

>   Unrecognized database format 'C:\Database\Begining Visual Basic 6 _
 >  \Biblio_2000.mdb

>   Of course I can use the original version to work on, but I wonder
w> hat is the way to overcome the problem with the new version of the
d> atabase.

>   I appreciate if you can provide me any solution.

>   Thank you.

> Regards,
M> ike Yeap