Program won't run on Vista Home or Windows 7 Home

[tim8w]

I have a program originally compiled in VS2008 on a WindowsXP Pro box. The program uses Microsoft DAO 3.5 Object Library to access an Access database.

When I try and run the program on Windows XP (any version) it runs just fine. If I try and run in on Vista (any version) it doesn't work. When I try and run it on Windows 7 Pro, it runs fine. I really want it to run on Windows 7 Home Premium, but I get an interop error anytime I try and access the database. Any idea why?

[Dnereb]

Are they by any change 64 bit and the XP systems not?
maybe you've set the advandced compile options for your project to x86

[tim8w]

Yes. It runs fine on every 32bit OS I tried. So how do I build it on my Windows XP 32bit machine so that the application AND installer will work on 64bit OS's?

[jmcilhinney]

I think that more likely the issue is that you've compiled for Any CPU, so it won't run on a 64-bit system because there's no 64-bit version of DAO.

First up, do you really need to use DAO? What exactly are you doing that you can't do some other way? If there's a more current way to do what you're doing, I suggest that you use it.

Next, can you confirm or deny that it works on all 32-bit systems and fails on all 64-bit systems? If that is the case then it is most certainly your target platform. In that case, change the build platform from Any CPU to x86, rebuild and you're good to go.