Making a copy of the current database using code

In the database that I am creating I need to be able to rename the file
with a name that the user specifies using the Save As Dialog window (I
already have the code that brings up this window). In other words, I
need to write code that makes a copy of the current database and saves
it with a new name. I've read that it is a bad idea to copy a file
that is currently in use so I am at a loss of what I should do. Any
suggestions?

.

Relevant Pages

  • Re: Problems with DataSets in DataSources window when renaming the source database
    ... They are naturally displayed and available in the DataSources ... When I rename the database I obviously also change the database name in the ... I have also done some more testing and it seems like the DataSources window ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: MS Access "Upsizing" Tools in SQL Server
    ... Create the database manually (on SQL Server 2005), ... window, choose Link Tables, choose ODBC Databasesand then choose the DSN ... You'll want to rename the old tables to "tableName_old" then rename the ...
    (microsoft.public.sqlserver.tools)
  • Problems with DataSets in DataSources window when renaming the source database
    ... I have a set of typed datasets that are tied to a database on a mssql2005 ... window. ... How can I rename the database and keep the current set of typed datasets? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Message Alert
    ... You or another user can press the F11 key to show the database window ... So the two strSQL lines needs to be changed also: ... assembled strSQL by pressing Ctrl + G, which opens the Immediate ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access/Comcast/Digital Conversion
    ... I did use the Shift-Key trick and that did open the database object window. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)