I have macros that run early AM that update data tables on other network drives. Is there a way in Access that I could run the database macros locally on my machine, then copy the entire database to their network? I looked at the macro options, but only saw the options for copying tables and/or queries. Didn't see anything about copying entire databases. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need Advice on Process to update Database tables each morning
- Thread starter RDM23
- Start date
Have a look at FileCopy in Help. You could:
1. Copy the network data mdb to an 'archive' folder, &/or rename it, eg myNetworkData.mdb to myNetworkData_2007-07-25.mdb
2. Delete the network copy (see Kill in Help)
3. Copy your local updated file to the network.
Max Hugen
Australia
1. Copy the network data mdb to an 'archive' folder, &/or rename it, eg myNetworkData.mdb to myNetworkData_2007-07-25.mdb
2. Delete the network copy (see Kill in Help)
3. Copy your local updated file to the network.
Max Hugen
Australia
- Status
Similar threads
- Locked
- Question