ACC97: 20 Character User Name in Secured DB Causes Errors

The "Database specifications" topic in Help for "Number of characters in a user name or group name" states that the maximum number of characters is 20. However, when you log on to a secured database with a username that is exactly 20 characters long, you receive one of the following error messages when you try to open an object in the database:

Create user accounts with names that are fewer than 20 characters long.

Microsoft has confirmed this to be a problem in Microsoft Access 97.

Steps to Reproduce Problem

WARNING: Following these steps will cause a general protection fault on your computer. Make sure you save and close any open work on your computer before following these steps.

1. Log on to a secured Microsoft Access database as a user with Admin permissions.
2. On the Tools menu, point to Security, and then click User And Group Accounts.
3. In the User And Group Accounts dialog box, click the New button on the Users tab.
4. Create a new user. Type TwentyCharacterUName in the Name box, and type 1234 in the Personal ID box. Click OK to close the New User/Group dialog box, and then click OK again to close the User And Group Accounts dialog box.
5. Quit Microsoft Access.
6. Start Microsoft Access 97. In the Logon dialog box, type TwentyCharacterUName in the Name box, and then click OK.
7. Open the sample database Northwind.mdb.
8. Open the Employees form. Note that you receive an error message, and then Microsoft Access quits.

For more information about implementing Microsoft Access security features, search the Help Index for "security."