Knowledge Base

ACC2: User() Function Not Supported in MS Access Version 2.0

Article ID: 119994

Article Last Modified on 7/5/2002

APPLIES TO

Microsoft Access 2.0 Standard Edition

This article was previously published under Q119994

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

SYMPTOMS

Both the Microsoft Access version 2.0 "Language Reference" manual and the online Help system state the following:

Microsoft Access version 2.0 supports the User function for backward compatibility. However, it is recommended that you use the CurrentUser function.

This information is incorrect.

RESOLUTION

The User() function is not supported in Microsoft Access version 2.0. If you compile a module containing the User() function, you will receive the following error message:

Expected: expression

Use the CurrentUser() function in Microsoft Access version 2.0 instead of the User() function.

REFERENCES

Microsoft Access "Language Reference," version 2.0, page 130

For more information about the CurrentUser() function, search for "CurrentUser," and then "CurrentUser Function" using the Microsoft Access Help menu.

Keywords: kbprogramming KB119994

Microsoft KB Archive/119994

Contents