Show All

Show SQL Server properties (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

1. Point to the View menu and click Server Properties.
2. The Server Properties dialog box is displayed with following information:
   • The database product (Microsoft SQL Server).
   • The database version number (8.0, 7.0, or 6.5).

     Note  8.0 refers to SQL Server version 2000.

   • The name of the database server.

   • The current SQL Server database name that the Microsoft Access project is connected to.

Note  The current SQL Server database name, along with the file format (Access 2000 or Access 2002 - 2003), is also displayed in the database window title bar to the right of the Access project file name.