Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

acess .mdb connection also requests .mdw connection

Status
Not open for further replies.

hsandwick

Programmer
Sep 10, 2001
286
US
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. However, 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top