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

ID: Q119994

The information in this article applies to:

Microsoft Access 2.0

SYMPTOMS

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

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 : kbprg
Version : 2.0
Platform : WINDOWS
Issue type :