VB 6.0 with Access 2007

[TMize]

I have previously written a VB6 program which accesses an Access database. Since I've updated to Access 2007, I can no longer test the program.

When I run the "EXE" of the program, it works fine.

When I try to test (run) the program within Visual basic 6.0, I get the following message"

"couldn't find installable ISAM"

Is there something I need to change/replace/upgrade in Visual basic 6.0, to make it testable???

Thanks - Tom

[dglienna]

Show the connection string that you use. Another option is LATE BINDING, so that it doesn't matter which version of Office your program uses, as long as it finds one

[twboiid]

I had a similar problem when I first switched to Access2007 (when trying to connect to .accdb database files).

If you were using the Microsoft DAO 3.6 Object Library, try removing the reference to it and instead, set a reference to Microsoft Office 12.0 Access database engine Object Library.

This solved the issues for me.

[DataMiser]

DAO ... uugh.

I use ADO and have not had any problems with any version of Access database

[dglienna]

Download the link in my signature, and get fully working code that shows how to write to controls without having to use BOUND CONTROLS.