DoCmd.CopyDatabaseFile

Copy the database connected to the current project to a SQL Server database file for export.

Syntax
      DoCmd.CopyDatabaseFile(DatabaseFileName,
                     OverwriteExistingFile, DisconnectAllUsers)

Key
   DatabaseFileName      The name of the file (and path) to which
                         the current database is copied.
                         default=current directory.

   OverwriteExistingFile Determines whether Access will overwrite any
                         existing file specified by DatabaseFileName.
                         True to overwrite the existing file.

   DisconnectAllUsers    Determines whether Access disconnects any users
                         connected to the current database in order to
                         make the copy.  True to disconnect users.

The file name of the file must have an .mdf extension.

To succeed, Access must be able to lock the destination file and have full access to the source database (no pending design sessions.)

DisconnectAllUsers might fail if any users have an exclusive lock on any database objects.

The current user for the Access project will need system administrator privileges for the database server.

Examples

DoCmd.CopySQLDatabaseFile DatabaseFileName:="C:\Demo\SS64.mdf", _
OverwriteExistingFile:=True, DisconnectAllUsers:=True

“We could have saved the Earth but we were too damned cheap” ~ Kurt Vonnegut, Jr.