Connecting CMC to an MS Access Database

Hi,

I have created an MS Access Database and I can run reports through Crystal Reports Client. However when I upload the report to CMC then schedule the report I get a message "Unable to connect: Incorrect Login Parameters". I have tried to map the folder the database is located but that has not seemed to help.

I did go through the steps to create the Access DSN but even when using this connection I still get the same error.

I have tried changing the file type from accdb to mdb and this still has not worked.

Is there any step by step guide to setup the connection?

Thank You

Ryan