VB6 front end to Access 97 db

M

mscertified

Converting Access 97 to 2000, found one application that uses an Access 97
database from a VB6 front-end.

I'm not really a VB6 programmer but I opened the project and looked at the
code. I think this was the first VB6 program someone wrote!

It connects to Access via:
Set goConn = New ADODB.Connection
goConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" _
& "Data Source=" & App.Path & "\Srtsdata.mdb"

I'm not sure where 'App.Path' comes from.
My question is what needs to change (if anything) when I convert the
database to Access 2000.

- David
 
D

Douglas J. Steele

Path is a property of the App object. It refers to the folder in which the
executable resides.

For Access 2000, you'll need to change the provider to
Microsoft.Jet.OLEDB.4.0.

You might also want to read the following KB articles:

PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or
2002:
http://support.microsoft.com/?id=238401
FIX: The Data Form Wizard May Not Open an Access 2000 Database:
http://support.microsoft.com/?id=242010
HOWTO: Modify the Visual Data Manager (VISDATA) to Work with Access 2000
Databases:
http://support.microsoft.com/?id=252438
FIX: Unrecognized Database Format Error with Data Control or Data Form
Wizard:
http://support.microsoft.com/?id=257780
 
Top