How to connect to Access database using MDW

Ok so I am using the trial of Crystal Reports to see if this will help my issue however I can't even get started.

I can connect to unsecured Access databases fine. However mine uses a MDW file with different login/password accounts. In designer mode, I can specify the mdw file, connect to my database, and even preview the data in the designer.

I tried added a Crystal Reports viewer to a form and linked it to the report. However when I run my application, it prompts me to log in. Nothing I type in will let me log into the database. I cannot figure out how to specify the proper connection. I also do not understand why the connection works in designer mode but not in the viewer