Windows 7 Compile creates RT 430?

I have a program compiled in windows 7 which keeps delivering the Runtime 430 automation error when executing it on XP and older OS's. This error is known to be related to the incorrect MDAC version. If I compile this same program, with the same options, on an XP box, this error does not occur.

From what I understand Windows 7 uses WDAC while XP and older use MDAC.

So how do we use ado.db connections for SQL in windows 7 while being able to compile the program so the exe will correctly function in windows XP?

Thanks

Welcome to VBForums :wave:

If you have installed SP1 for Windows 7, this kind of issue is expected.

There is a link explaining how you can fix it in the "General" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum)

thanks, I found it. I will post tonight after I see if that fixes it.

ok although I found the article, the tlb files there will not register in windows 7, or I have become a moron whereas registering a file is concerned.

Can someone give me a step by step to register these tlb that will actually work? I have tried about 5 different things I have looked up and all failed.
I dont think that the ms supplied tlb would be bogus, any particular way to do it in windows 7?

Thanks for the help, I got it to work.

This is resolved, thanks again! !