ACC97: 20 Character User Name in Secured DB Causes Errors

• Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

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:

   MSACCESS caused a stack fault in module KERNEL32.DLL

   -or-

   MSACCESS caused a stack fault in module MSJET35.DLL

RESOLUTION

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

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

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" (without the quotation marks) in the Name box, and type "1234" (without the quotation marks) 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" (without the quotation marks) 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.

REFERENCES

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