Show All

Drop a database (ADP)

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

You can drop a database in Microsoft SQL Server 2000 Desktop Engine from a Microsoft Access project. To drop a database in SQL Server, you can use the DROP DATABASE Transact-SQL statement, or use SQL Server Enterprise Manager. For more information on the DROP DATABASE statement and SQL Server Enterprise Manager, see the SQL Server documentation.

Note  Dropping a database permanently deletes the database. To drop a database, you must disconnect all users from the database and close all windows except the Database window.

1. Open an Access project connected to SQL Server 2000 Desktop Engine.
2. Point to Database Utilities on the Tools menu and then click Drop SQL Database.

   Microsoft Access confirms the operation. Click Yes to drop the database.