access mdb connection also requests .mdw connection for system db

vb .net2002
crystal reports 9

Hi, I have a regular .mdb that's called in my app as a subreport, works fine.

I have another .mdb that's called as another subreport, seems to be a security issue. I set it up as an m_cnadonetconnectionstring using microsoft jet oledb 4.0 provider. I include the uid and pwd. But, it needs me to also input info about the .mdw as otherwise I get an error msg that it can't find the workspace and to contact admin.

Now I'm able to get data with the troublesome one, but the "request pwd" box appears. All my other connections in the app do not show the "request pwd for connection" box. I don't want this box appearing, just want to go straight to the report. Why is this happening?

Thanks for any advice.

Helen