Copy of current database

  • Thread starter Thread starter Dorian Chalom
  • Start date Start date
D

Dorian Chalom

Is it possible to create a copy of your current database through code?

I have a data base and the only difference between the district database and
the schools version of the database is the tables are not copied over. So i
had this thought why don't I create a routine that woulkd copy over
everything needed from the current database to another database excluding
the datatables for the schools to use?

Is it possible? And How would i do it?
 
Dorian said:
Is it possible to create a copy of your current database through code?

I have a data base and the only difference between the district database and
the schools version of the database is the tables are not copied over. So i
had this thought why don't I create a routine that woulkd copy over
everything needed from the current database to another database excluding
the datatables for the schools to use?
Click to expand...

You should never copy an open file, especially a database
file.

Use a batch script or another program to copy the database.
 
I have the same sort of set up...

I have a module with the following code



Function A()
Dim objReport As Object ' Generic object
variable

For Each objReport In CurrentProject.AllReports
DoCmd.TransferDatabase acExport, "Microsoft
Access", "\\Esco_fs6\Marketing\DataBases\Sales
Database.mdb", acReport, objReport.NAME, objReport.NAME
Next objReport

Dim objForm As Object ' Generic object
variable

For Each objForm In CurrentProject.AllForms
DoCmd.TransferDatabase acExport, "Microsoft
Access", "\\Esco_fs6\Marketing\DataBases\Sales
Database.mdb", acForm, objForm.NAME, objForm.NAME
Next objForm

Dim objMacro As Object ' Generic object
variable

For Each objMacro In CurrentProject.AllMacros
DoCmd.TransferDatabase acExport, "Microsoft
Access", "\\Esco_fs6\Marketing\DataBases\Sales
Database.mdb", acMacro, objMacro.NAME, objMacro.NAME
Next objMacro
End Function



Then I have a macro set up with a line that says RunCode
and then the code is "A"
 
But I have modules too to copy over. So I guess I could create this code in
a seperate module and in the module part of the transfer over filter out
this module with an IF...ENDIF so it would not copy this opwen module.

Yes????
 
OK but the program is not a centralized program each school has thier own
copy of it adn I want to get away from having to create the users version
every year for them.
 
Back
Top