Re: VB 6.0 with Access 2007
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
Re: VB 6.0 with Access 2007
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.
Re: VB 6.0 with Access 2007
DAO ... uugh.
I use ADO and have not had any problems with any version of Access database
Re: VB 6.0 with Access 2007
Download the link in my signature, and get fully working code that shows how to write to controls without having to use BOUND CONTROLS.