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.

MORE INFORMATION

Steps to Reproduce Problem

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

Additional query words: IPF Stackfault security login account length gpf ipf

Keywords          : kberrmsg ScrtUsr 
Version           : 97
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 23, 1999