ACC97: 20 Character User Name in Secured DB Causes Errors (167235)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q167235
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

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.

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 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.

REFERENCES

For more information about implementing Microsoft Access security features, search the Help Index for "security."
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kberrmsg KB167235
©2004 Microsoft Corporation. All rights reserved.