03-09-2017 06:03 AM
I'm currently trying to link Crystal Reports XI to Act Pro 18.
The Act database is on a server and the .pad file is on a shared drive. I have Act installed locally on my PC.
I can see Act OLE DB provider for reporting 2.0 within Crystal when I go to create new OLE DB connection. Upon entering the file path, username and password I get a permission denied error, source: Provider.
I've tried connecting using the database name and databasename.pad on both datasource and the database line, neither work.
Can anyone point where I am going wrong? or confirm these 2 versions are compatible as I know the Crystal I am using is quite old.
I can connect to Excel using OLE DB.
Thanks in advance!