When you convert the Microsoft Access 2.0 sample database NWIND.MDB to Microsoft Access 97, you receive the following error message:

Back to the top

The version of Microsoft Visual Basic for Applications in Microsoft Access 97 has the same naming restrictions as the full version of Microsoft Visual Basic 5.0. This version of Visual Basic for Applications now restricts the use of the following keywords as identifiers in a Visual Basic for Applications module: When you convert a database from an earlier version of Microsoft Access to Microsoft Access 97, existing identifiers that are the same as new Visual Basic keywords cause a compile error.

In this example, NWIND.MDB uses an identifier called Event in the ShowEvent procedure of the Utility Functions module.

Back to the top

After you convert NWIND.MDB to Microsoft Access 97, do the following to fully compile the project:

1.	Start Microsoft Access and open the converted NWIND.MDB.
2.	Open the Utility Functions module in Design view.
3.	On the Debug menu, click Compile Loaded Modules.
4.	Click OK when you receive the compile error message.
5.	Modify the ShowEvent procedure to read as follows: Sub ShowEvent (Event_var As String) ' Accepts: a text value, the type or name of an object and the name ' of an event. ' Purpose: displays an event history list in the Event History form. If IsNull(Forms![Event History]![History]) Then Forms![Event History]![History] = Event_var Else Forms![Event History]![History] = Event_var & Chr(13) & _ Chr(10) & Forms![Event History]![History] End If End Sub
6.	On the Debug menu, click Compile and Save All Modules.

Back to the top

For more information about reserved keywords in Microsoft Access 97, search the Help Index for "scoping levels," and then view the topic "Scoping and Object-Naming Compatibility."

Back to the top