Connecting a Vb5.0 App with Office 2000 Table

[clayn]

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.

[shakin_tree]

I got the same problem. The best solution I can think of is to check Microsoft for a newer version of the datacontrol.

[Vlad Chapranov]

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

[thorne]

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