I've created an application which works fine on my PC. Now I've installed my applications with crystal reports reports in the past with no problem what so ever, but all those databases were within Access 97.

This time I've used SQL 7 and when I install the application everything works fine expect the reports. I keep getting the message 'The library pdssql.dll' cannot be found. Now the weird thing is, its not even on my PC yet everything works okay.

Has anyone come across this problem and could help me solve it.