ACC: No Password Prompt Using Microsoft Access .MDB with ODBC (112346)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q112346 SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
You are not prompted for a user name and password as you would expect when
you are using ODBC from an application to open a secured Microsoft Access
database.
CAUSE
You have not specified a Microsoft Access workgroup information file
(System.mdw in Microsoft Access version 7.0 or 97, or System.mda in version
1.x and 2.0) to use with the Microsoft Access ODBC data source. The
workgroup information file contains a list of users, groups, and passwords.
If you do not specify a workgroup information file, ODBC will open your
Microsoft Access database (.mdb) file without a password as a member of the
Users group, with the permissions of the Users group.
RESOLUTION
Edit the Microsoft Access ODBC data source to use the appropriate Microsoft
Access workgroup information file.
NOTE: For Microsoft Access 1.x and 2.0, the drivers do not
allow you to specify a workgroup information file in the setup of your ODBC data source. At this time, there is no resolution for this problem if you are using Access versions 1.x or 2.0.
Follow these steps to specify a workgroup information file to use in a
Microsoft Access ODBC data source:
- Start Control Panel.
- Double-click the ODBC icon.
- In the ODBC Data Source Administrator box (or Data Sources in Microsoft
Access 7.0 or earlier), select the Microsoft Access data source you
are using, and then click Configure (or Setup in version 7.0 or
earlier).
- In the System Database box, click Database.
- Click the System Database button.
- In the Select System Database box, locate and select the appropriate
workgroup information file (System.mda or System.mdw).
- Click OK, and then close the ODBC Data Source Administrator.
MORE INFORMATION
If ODBC opens your Microsoft Access database without a password, this does
not mean that you have circumvented Microsoft Access security.
Microsoft Access employs user-level security on databases, not share-level
security. In user-level security, you grant permissions to users of your
database resources, such as tables and forms. In share-level security, you
password-protect your resources.
If ODBC opens your Microsoft Access database without a password, you will
log on to the database as a member of the Users group and will only have
permissions to objects in the database that are available to members of the
Users group.
If members of the Users group do not have permissions to edit data in a
table, you will not be able to edit that table using ODBC with no
System.mdw file specified.
In user-level security, the combinations of users and their permissions
define database security. Information about users, groups, and passwords is
stored in a workgroup information file. Information about who has
permissions on database objects is stored with each database in the
Microsoft Access database (.mdb) file.
Passwords are stored in the workgroup information file, and are used only
to prevent a user from logging on to a database as another user who has
different permissions on database objects. Members of the Users group may
not have permissions to modify data in tables, but a user with a password
may have permissions to modify data in the tables.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kbprb kbusage KB112346 |
---|
|