Permissions Issue in Crystal - MSAccess AS400

[jpalmer150]

I'm trying to connect Crystal to an MS Access database. The Access DB has tables within it that are linked to a secured AS400 ODBC DSN.

When attempting to connect to the Access database Crystal says that I do not have permissions for the linked AS400 table.

Anybody know why Crystal isn't prompting me for my username and password for the AS400 DB?

 

[jpalmer150]

Fixed my problem. I was using the Workgroup Administrator in MSAccess and it was causing problems. I imported all the tables and queries into a blank Access Database to remove the security and that fixed it.

Problem solved...

-JP