I am currently trying to figure out why my software refuses to run on Windows 7 x64 Home Premium.
When a user tries to log in the software queries a .mdb to authenticate the user however it will throw the following error:
"System.InvalidOperationException: The .Net Framework Data Providers require Microsoft Data Access Components (MDAC). Please install MDAC version 2.6 or later."
On face value it seems like an easy fix (and maybe is for some of you ;)) but MDAC is no longer supported in Windows Vista or Windows 7 being replaced by Windows Data Access Components (WDAC), which to my knowledge, are built into the core directly.
Currently I have 2 scenarios in mind:
1: Windows 7 Home Premium does not include some of the data access components required by the software with the solution being upgrading my licence to Professional or higher.
2: The software is trying to use a legacy data provider that is no longer supported in WDAC. The connection string I am using is: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=pathtodb.mdb";
According to my research that connection string is OK.
I should also mention that this works on a system running Windows 7 x86 Professional edition.
Any help with this would be greatly appreciated.
Troy