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.
“We could have saved the Earth but we were too damned cheap” ~ Kurt Vonnegut, Jr.