I have VB6 on Win98, and took a VB class a few years ago. The class taught us how to create a database on Access 97 and use the Data Control in VB6 to connect to the MDB file and we learned how to add, edit, delete and search the db. Now I have a project which actually incorporates this method. Except now, I have Access 2000 and VB6 apparently doesn't like the new version's MDB files. So then I noticed Access 2000 can export a table to various formats such as dBASE III, IV, 5.0 and some Excel formats, and that the VB6 data Control's Connect property can use many of these same formats. Yet even though I made them match, VB6 refused to understand anything that Access 2K put out, reglardless of file format. So now my question is basically: how to get VB6's Data control to work with an Access 2000 mdb database? Is there some kind of small app that will retro-convert tyhe mdb file, or perhaps an ocx I can download to update VB6 into handling this task? Any hints would be greatly appreciated. Thanks in advance.

It's been so long, that I don't remember the code, but I've connected to Access 2000 db's plenty of times with VB6... but I never used the data access control, always did everything through code. The one thing I can suggest is that maybe you might have to update your mdac... try this link as a starting point.

Piece of cake. You need SP 5 for VS6.0 you can download it off of the microsoft site. Also mdac2.5 i think is and jet4.0. The service pack is like 58 Meg so make sure you have a decent connection to download it. I have a bunch of apps that im doing this with. If you want some sample code, shoot me an email and ill send you some. CJ

instead of using msaccess you may use the addin that goes with vb6, the visual data manager, aka visdata.exe, you may create here your databases and it is compatible with access and vb

Convert the Database file within Access. Tool->Database Utilities->Convert Database. had the same prob, but then this worked. Hope it works.

Additionally, to treat .mdb with VDM after installing SP4 make this: http://support.microsoft.com/default.aspx?scid=KB;en-us;q252438