Programming Forums

Programming Forums (http://www.programmingforums.org/forumindex.php)
-   Visual Basic (http://www.programmingforums.org/forum18.html)
-   -   Vb6 App from Access97 to Access2002 (http://www.programmingforums.org/showthread.php?t=14409)

rednek Nov 10th, 2007 4:50 PM

Vb6 App from Access97 to Access2002
 
I'm trying to get an old VB6 app I wrote in the mid nineties back to life ...
I have to change from Access97 to 2002 so I can work the database. I did the Access conversion without errors but VB6 screamed at me when I fired the App up!
"Run-time error 3343 Unrecognized database format"

My code at startup goes as follows:
[gsLocalDB = app.Path & "\Local97.mdb"]

It was this next line that caused the error...
[Set dbRate = DBEngine.Workspaces(0).OpenDataBase (gsLocalDB)]

General Declarations
[ Public gsLocalDB As String]
[ Public dbRate As Database]
[ Public wsRate96 As Workspace]

Local97.mdb is the database I'm trying to open in Access2002.

Can anyone suggest a cure?
Many thanks,
Ken


All times are GMT -5. The time now is 9:48 PM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC