[RESOLVED] impossible to connect data environment to database

[dilettante]

I'd guess you are just letting Jet default to using the user's "default" .MDW system database (Workgroup Information File). Most newbs do this though it can present problems and be insecure.

However you have complicated the issue by setting a share-level password on the database and then you try to use this as a user-level password. Kaboom. The error is telling you that the user/pw you specified isn't in the default MDW.

Instead you have to provide the share-level password as the correct Connection property. This is not Password but instead the extended property Jet OLEDB:Database Password.


Don't worry about people who don't know how to use a DataEnvironment (which is not a "control"). They seem to have limited knowledge of ADO usage based on copy/paste script snippets floating around that date back to early ASP scripting days. There is nothing "indirect" about using a DataEnvironment and this is actually the preferred approach for most scenarios.