I have written a VB6 application that connects to an MS Access database using the following connection string:

Code:
myConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myFilePath & ";"
This works fine on the computer that has Visual Studio 6 installed on it but when I deploy this to a test machine it gives me an error when trying to connect to the database. I think it must be something to do with it not finding the provider?

Both my test and development machine are Windows 7 x64 and both have up to FrameWork 4.0

Any ideas?

Thanks

Simon