Resolving DAO and other dll conflicts between XP and Windows 7

I have a VB6 program that uses an MS Access database and runs happlily on XP. When I package it for install and try to install it on a Windows 7 machine, I get "version conflict" mesages for several dlls, notably MSVCRT, msjter40 (and the others associated with the Jet engine and installed on $WinSysPathSysFile) and dao360 (installed on $MSDAOPath). I seem to remember there is a way of having multiple DLLs versions to get round this but haven't been able to find much on how to do this. Can anyone help, or point me at an article on resolving this? I don't want to disturb any of the newer versions - but if I choose to keep them, I can read from the database but not write to it.
MikeDigginsAsked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
You need to read that article.  Jet isn't supported on 64-bit either.  They really want you to use SQLEXPRESS now instead of Access.  And access 2007 / 2010 use a different driver in any case.
0
 
Dave BaldwinFixer of ProblemsCommented:
This page http://msdn.microsoft.com/en-us/library/ms810810.aspx says that DAO is not supported after Windows XP.  And there is no 64-bit version of it.
0
 
MikeDigginsAuthor Commented:
Thanks Dave, in that case I should be able to run it in XP compatibility mode, or am I being overly hopeful? If I alter the code to use ADO instead, do I still need XP compatibility mode, please?
0
 
MikeDigginsAuthor Commented:
Very persuasive - decided to use XPMode as a stopgap while getting rid of Access. Beeen looking for an excuse for a long time, truth be told. XPMode did everything it promised to - impressive result. Thanks for the pointer to what I should be doing!
0
 
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.