access mdb connection also requests .mdw connection for system db

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Helen (Helen_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 11:40:02 -0700

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

Relevant Pages

  • access .mdb connection also requests .mdw system .mdw connection i
    ... Hi, I have a regular .mdb that's called in my app as a subreport, works fine. ... Thanks for any advice. ...
    (microsoft.public.vb.crystal)
  • Re: Error - Error Accessing File. Network Conn..." File Corruption?
    ... > consuming problem receiving the error message "Error Accessing File. ... > truly clean up an mdb? ... Sometimes the app ... > - Does anyone know of a good site dealing with Access file corruption? ...
    (microsoft.public.access.formscoding)
  • Re: hidden database window shows on exit
    ... Perhaps someone else who has struggled with a similar corporate environment can give you advice here. ... So my perception is that the SPs for A2003 are not as crucial as they are for A2000 or A2007 where you're a self-styled martyr if you don't apply at least SP1. ... The app is a pretty standard Secured MDE FE / MDB BE, ...
    (comp.databases.ms-access)
  • simple symetric encryption advice
    ... I would like some advice on what crypto lib to use. ... app that will store sensative data in a backend postgresql server. ...
    (comp.lang.python)
  • Re: Rapidly expanding MS Access data file size
    ... I suggest you use a temporary .mdb file for the temporary tables. ... delete the bloated .mdb file and start the next import-process-upload ... >I have a small Access 2000 app that whilst working is causing some concern. ...
    (microsoft.public.access.externaldata)