It has to do with the OLE Provider you are using ... Access 97 uses Jet
3.51 and Access 2000 uses Jet 4.00 and is backward compatiable

This all means you have to change your connection string. I suggest
dragging the Microsoft ADO Data Control v6.00 onto a form and selecting
"custom ..." in the properties window. From here select the Jet 4.00
provider and you will automatically be able to rebuild you connection
string. Cut and paste the string into your application.

Cheers
Zane Gers



                                                                                                                                    
              Jimmy Willett                                                                                                         
              <Jimmy.Willett@n...         To:      "professional vb" <pro_vb@p...>                            
              t>                               cc:                                                                               
                                               Subject: [pro_vb] Access database                                                    
              07/05/2002 12:04                                                                                                      
              Please respond to                                                                                                     
              "professional vb"                                                                                                     
                                                                                                                                    
                                                                                                                                    



I have an application written in VB6 using an Access 97 database.  I had
to convert the database to Access2000 due to the upgrades in the
package.
However, since conversion, I get an error each time I reference the
database..."Unknown database format"
The database converted ok, and went thru the correction and compacting
ok....
I can open the database in Access and query, look, etc,etc....with no
problems
Any help would be appreciated...
thanks
Jimmy Willett





This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.