Solved

Resolving DAO and other dll conflicts between XP and Windows 7

Posted on 2011-09-28
5
1,176 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:MikeDiggins
  • 3
  • 2
5 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 36715488
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
 

Author Comment

by:MikeDiggins
ID: 36715957
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
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 36718570
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
 

Author Closing Comment

by:MikeDiggins
ID: 36890013
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 36890058
You're welcome, glad to help.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question