Printable View
I have been working on an Vb 5.0 application that connects to Access databases. I have had no problems reading and writing to these tables until I recently upgraded to Office 2000. Now I am recieving an error message unrecognizable format when I try to connect to a database saved under Access 2000. Has anybody heard anything about this problem.
I got the same problem. The best solution I can think of is to check Microsoft for a newer version of the datacontrol.
I encountered this problem 2 month ago, when Microsoft gave me Access 2000 (I'm MSDN subscriber and most products I get sooner than anybody else). Since that I was able to find the only solution: Create DAO Recordset object and set Data Control Recordset property to that recordset. In my case it doesn't work, because I have pretty complicated logic in some procedures, which use some of the features of DC and it requires redevelopment. Too much time. With new project I think it's not difficult. But be aware, Crystal Reports (latest version) doesn't recognize new database format either.
Seagate is working on it and promises to give new DLLs soon.
Vlad
Access 2000 databases have a different format or something. VB 5.0 and 6.0 don't recognize the new format as a valid database. If you have access to the database itself, then you can convert the 2000 database into an older version. VB will then recognize the format.
Tools | Database Utilities | Convert Database will give the option of converting from an older version to 2000 or vice versa. Hope that helps