I have an .MDB database for which a password (shared-level security) has been set.
The .MDB database also uses a corresponding .MDW workgroup database, to manage the respective username and password of every individual user (user-level-security).
For a user to successfully connect to the database, the workgroup file, username (user-level), password (user-level) and the database password (shared-level) need to be specified.
With OLE DB, this is pretty simple in a connection string:
- Workgroup file:
Jet OLEDB:System Database - Username (user-level):
User ID - Password (user-level):
Password - Database Password (shared-level):
Jet OLEDB:Database Password
However, with ODBC it seems there is an option missing:
- Workgroup file:
SYSTEMDB - Username (user-level):
UID - Password (what level?):
PWD
According to SQLConfigDataSource (Access Driver), the PWD option is the only password related one. However, the description just says The password., without specifying which one, or how to use it.
So how can I specify both, user-level and shared-level passwords, in a single ODBC connection string PWD option?