Visual Basic&database, Access 2000 with VB6.0

Access 2000 with VB6.0 - Stopped working...why?

Author	Message
Stev #1 / 3	Access 2000 with VB6.0 - Stopped working...why? Hi. I'm a bit of a newbie, so I apologize for the question if it's been posted before, but I have a program written in VB6.0 that accesses an Access 97 database via DAO and it works perfectly. However, when I convert the database to Access 2000, I get an error message when running my program that says: Runtime error '3343' Unrecognized database format 'c:\mydatabasepath\mydatabase.mdb' This seems to happen no matter what Access 2000 database I attempt to open (either a converted Access 97 one or a new database). Here's the line in my VB code: Private Sub Form_Load() Set dbs = OpenDatabase("c:\my documents\mytest.mdb") Set rsResults = dbs.OpenRecordset("Results", dbOpenDynaset) End Sub Am I doing something wrong? The error occurs on the line that reads 'Set dbs = OpenDatabase...' Any help would be greatly appreciated. If you wouldn't mind, please reply Thanks. Steve
Mon, 04 Aug 2003 14:15:49 GMT

Darren Kin #2 / 3	Access 2000 with VB6.0 - Stopped working...why? You will need to download the latest service pack to allow you to load the access 2000 database. You can get from www.microsoft.com/downloads Quote: > Hi. I'm a bit of a newbie, so I apologize for the question if it's been > posted before, but I have a program written in VB6.0 that accesses an Access > 97 database via DAO and it works perfectly. However, when I convert the > database to Access 2000, I get an error message when running my program that > says: > Runtime error '3343' > Unrecognized database format 'c:\mydatabasepath\mydatabase.mdb' > This seems to happen no matter what Access 2000 database I attempt to open > (either a converted Access 97 one or a new database). Here's the line in my > VB code: > Private Sub Form_Load() > Set dbs = OpenDatabase("c:\my documents\mytest.mdb") > Set rsResults = dbs.OpenRecordset("Results", dbOpenDynaset) > End Sub > Am I doing something wrong? The error occurs on the line that reads 'Set > dbs = OpenDatabase...' > Any help would be greatly appreciated. If you wouldn't mind, please reply > Thanks. > Steve
Mon, 04 Aug 2003 18:26:31 GMT

Cecil A Galbrait #3 / 3	Access 2000 with VB6.0 - Stopped working...why? Steve, If you look into the References dialog on your Project \| References menu item, you'll see that you have Microsoft DAO 3.5 Object Library selected (checked). Uncheck that and check the 3.6 version instead. Cecil -- ------------------------------------------- Cecil A. Galbraith http://www.codesoup.com Programmers Utilities/Tips ------------------------------------------- Quote: > Hi. I'm a bit of a newbie, so I apologize for the question if it's been > posted before, but I have a program written in VB6.0 that accesses an Access > 97 database via DAO and it works perfectly. However, when I convert the > database to Access 2000, I get an error message when running my program that > says: > Runtime error '3343' > Unrecognized database format 'c:\mydatabasepath\mydatabase.mdb' > This seems to happen no matter what Access 2000 database I attempt to open > (either a converted Access 97 one or a new database). Here's the line in my > VB code: > Private Sub Form_Load() > Set dbs = OpenDatabase("c:\my documents\mytest.mdb") > Set rsResults = dbs.OpenRecordset("Results", dbOpenDynaset) > End Sub > Am I doing something wrong? The error occurs on the line that reads 'Set > dbs = OpenDatabase...' > Any help would be greatly appreciated. If you wouldn't mind, please reply > Thanks. > Steve
Mon, 04 Aug 2003 20:52:20 GMT

Page 1 of 1

[ 3 post ]