We have an in-house app that writes to a Microsoft Access2000 DB that is
password protected. This database sits in a directory on the server and
there is no system.mdw file there. The application (its ASP) has no issues
with connecting. I need to periodically pull one table from it to SQL (for
reports). In setting up a DTS to do this it can't connect and I get the
error that the Workgroup Administration (mdw) File is missing". Seems to be
a known issue with password protected db's, but the fix is to use advanced
properties to point to the .MDW; but there isn't one.

Does anyone have an idea how I can either create one or get around this? I
copied the DB local to my PC and get the same error. If I take the password
off it connects fine but I am not sure I can or should remove the password
from the production DB except as a last resort.
--
Thanks,
Dave Hamblin

Hello DHamblin,


In the Access Connection Task do not set the password in the main textbox;
try 'Advanced' and set the Jet OLEDB property 'DataBase Password' (you 'd
better use disconnected edit).
Bye

Thanks, I had copied my local system.mdw to the directory the db is on on the
server; I got further but it kept balking about the login/password.

I left them blank on the initial screen as you suggested and entered the
password on the advanced (where I had pathed to the system.mdw) and its
working fine
--
Thanks,
Dave Hamblin


"Davide Rossetti" wrote: