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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top