Solved

Resolving DAO and other dll conflicts between XP and Windows 7

Posted on 2011-09-28
5
1,169 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 82

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 82

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 82

Expert Comment

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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Asus ks2003 driver XP 32 33 67
Making an alias 7 51
Visual Studio 2005 text editor 10 18
What is this Task? 4 34
Issue: Unstable cursor in Windows XP and Windows runs extremely slow in that any click will bring up the Hour glass (sometimes for several seconds before giving you what you want) . Troubleshooting Process and the FINAL FIX: This issue see…
First some basics on Windows 7 Backup.  It has 2 components one is a file based backup which is stored in .zip files each zip is split at around 200 Megabytes and there is the Image Backup which is as the name implies a total image of the partition …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now