Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
SUMMARY
In Access, you can set conditional compilation arguments through the user interface. In Access 97, you could set conditional compilation arguments on the
Advanced tab of the
Options dialog box (on the
Tools menu). In Access 2000, the conditional compilation arguments setting has been moved to the Visual Basic Environment. In Access 2000, you can find the setting on the
Tools menu under the
<ProjectName> Properties command, where <ProjectName> is the name of your database project.
For example, to find the conditional compilation arguments setting in Access 2000 for the sample database Northwind.mdb, follow these steps:
- Open the sample database Northwind.mdb.
- In the Database window, press ALT+F11 to switch to the Visual Basic Environment.
- On the Tools menu, click Northwind Properties.
Note that the Conditional Compilation Arguments box appears on the General tab.