I write a few programs in VB6 and use access as a database but VB6 only talks to Access 97 and all of our PCs at work have Access 2007. what is the best way to get around this when I have to make changes to tables etc.
Reply from Richard Rost:
Ron, I'm not familiar with any method of connecting to an ACCDB file (Access 2007) from VB6. I've never tried it. I would suggest, if possible, save your Access databases in the Access 2000 file format (which will still work with AC2007 front-end databases). If that's not possible, try a Google search and see if there is a DLL or other code out there that someone has developed for this. I'm sure Microsoft wants you to upgrade your version of VB though.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
VB, VB.NET, VBA.