You can use the CopyDatabaseFile macro action to make a copy of the current Microsoft SQL Server 7.0 or later database connected to your Access project (*.adp). Access detaches the current database and then attaches it to the destination server. For more information about detaching and attaching a database, see the SQL Server documentation.
Note: This action will not be allowed if the database is not trusted.
Note: Access 2010 is the last version that supports Access data projects.
Setting
The CopyDatabaseFile macro action has the following arguments.
|
Action argument |
Description |
|
Database File Name |
The name of the new Master Data File. The default path for the file is the current location of the Access project file (.adp). |
|
Overwrite Existing File |
Specifies whether or not to replace an existing file with the same name. If set to Yes and the filename already exists, the file is overwritten. If set to No and the filename already exists, the file is not overwritten and the action fails. If the file does not already exist, this setting is ignored. The default is Yes. |
|
Disconnect All Users |
Specifies whether or not Access should force users off the database. If set to Yes, any users that are connected to the current database are disconnected so that the copy database operation can proceed. If set to No and one or more users are connected to the database, the copy database operation fails. The default is No. Disconnecting users from a database without adequate warning can lead to data loss. |
Remarks
The copy operation is synchronous, so you can't perform other operations until the copy of the database is complete.
The CopyDatabaseFile macro action not only copies data, data definitions, and database objects, but also copies extended properties, such as default values, text constraints, and lookup values.
Requirements for copying a database:
-
You must disconnect all applications and users before you copy the database file.
-
All objects and views except the Navigation Pane must be closed.
-
The current database must not be replicated.
-
The source server database must be Microsoft SQL Server version 7.0 or later, or SQL Server 2000 Desktop Engine running on a local computer.
-
The SQL Server database on the source server must be a single file database.
-
You must be a member of the sysadmin role on both the source and destination SQL Server computers.
To run the CopyDatabaseFile macro action in a Visual Basic for Applications module, use the CopyDatabaseFile method of the DoCmd object.
