Microsoft KB Archive/167235

= ACC97: 20 Character User Name in Secured DB Causes Errors =

Article ID: 167235

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



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.



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.

