Crystal Report using Accpac & MS Access Databases fails 1

[karen999au]

Hello,
I am using Accpac 500 ERP (Version 5.5A), MS Access 2003 and Crystal Reports XI. In Crystal Reports I have created a report using tables from both Accpac and also a database I have created in MS Access. The report runs fine in Crystal Reports. I have put a link to the report in Accpac so others can utilise this report. However, when it is run from there Crystal Reports returns "Login failed". It is definitely the MS Access side that is causing this. Is it possible to take data from a MS Access Database & display it in a Crystal Report through Accpac and if so what is the solution to my problem - Thanks for any advise on this one.

 

[Jay Converse]

You have to put the MSAccess links in a subreport, not the main report.

 

[karen999au]

Thanks for your advise tuba. I did as you suggested and now I don't get the error message. However, when I attempt to run the report it closes Accpac down entirely and displays nothing before it exits.

 

[Jay Converse]

I can't explain that one, I've done it before in earlier versions. You may have to code your own Crystal wrapper. When you drop a Crystal report on the Accpac desktop it assumes all tables are Accpac tables.

 

[karen999au]

Ok thanks for your help...I'll potter around with it a bit more. Regards.

 

[vbdbcoder]

Here is the trick:

For your Access piece, create a file DSN to save your login crudentials: SERVER\DATABASE\USER NAME\PWD... (Make sure PWD is entered and saved using Notepad)

Save the file DSN in the proper folder on the server\client PC.

you should be okay even launching the report inside Accpac.

 

[karen999au]

Thanks vbdcoder,
Many thanks for your assistance. You are really getting into stuff I'm not familiar with. Nevertheless I created test.dsn and placed it on the client PC in C:\Program Files\Common Files\ODBC\Data Sources. Test.dsn looks like this:

[ODBC]
DRIVER=Driver do Microsoft Access (*.mdb)
UID=admin
PWD=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=0
PageTimeout=5k
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=U:\Databases\
DBQ=U:\Databases\Main.mdb

The Crystal Report running from within Accpac still generates the "Login failed" message. Does Test.dsn look anything like what I need ? What else is required ?
Thanks for your time.

 

[ettienne]

Did you create a FILE dsn?

 

[karen999au]

Hi ettienne,

Yes I believe so - I called it test.dsn please see my last post.

Thanks