"Unrecognized format"?
-
I created a database in Access 2000. I tried to use the following code in VB 6.0 to open that database: --- Dim wspDefault As Workspace Dim DB As Database, DBSet As Recordset ' Grab the default workspace. Set wspDefault = DBEngine.Workspaces(0) ' Open the database. Set DB = wspDefault.OpenDatabase("c:\temp\xxx.mdb") --- When I run it, though, it gives me error 3343: "Unrecognized database format". Is this because VB does not have / know the correct Jet DLLs to access a database created in Access 2000? They must exist otherwise how is Access doing it... If this is the problem, how / where do I get the right files, and where do I put them? If not, what have I done wrong?
-
I created a database in Access 2000. I tried to use the following code in VB 6.0 to open that database: --- Dim wspDefault As Workspace Dim DB As Database, DBSet As Recordset ' Grab the default workspace. Set wspDefault = DBEngine.Workspaces(0) ' Open the database. Set DB = wspDefault.OpenDatabase("c:\temp\xxx.mdb") --- When I run it, though, it gives me error 3343: "Unrecognized database format". Is this because VB does not have / know the correct Jet DLLs to access a database created in Access 2000? They must exist otherwise how is Access doing it... If this is the problem, how / where do I get the right files, and where do I put them? If not, what have I done wrong?
I'm guessing that you're using DAO, and I don't know too much about DAO. Make sure you have the latest version of DAO referenced in your project. Get the latest version of MDAC and Jet 4.0 SP3 here: http://www.microsoft.com/data/download.htm Otherwise, if you're willing to use ADO, I can come up with some code for you. Get the latest MDAC either way tho ;)
-
I'm guessing that you're using DAO, and I don't know too much about DAO. Make sure you have the latest version of DAO referenced in your project. Get the latest version of MDAC and Jet 4.0 SP3 here: http://www.microsoft.com/data/download.htm Otherwise, if you're willing to use ADO, I can come up with some code for you. Get the latest MDAC either way tho ;)