Automating Deployment of an access MDE.
Posted on 2008-06-26
Right now my process for deploying updates to a database called chm_tracker.mdb
to an access database includes
1.- Finishing up all the modifications and verifying that it works.
2.- Decompile the chm_Tracker.mdb
3.- Compact and Repair database
4.- ReCompile the database
5.- Make an MDE from the database that gets saved in a network location called "j:\shared\topio\shipping\"
6.- Notify all the users in the outlook list TrackerUpdates that a new version has been place on the server
This is what I want to automatize but I don't know if I can do this from inside the tracker database
or jsut create anew database with a very simple form to perform this activity.