G
Guest
I have created a system that uses a single database on a shared network to
store the company data (it is refered to as Master) and a database file
containing local tables, forms, and reports (refered to as Local) for our
employees to copy to their desktop and use. The system alows users to read
and write data when required to the master but function totally seperate in a
local environment. It is much quicker and works fine to date. However, when
a change to the system is required and I need the users to update their
local applications we run into a manual process that I would like to
automate. Right now the first thing the local does is to compare it's own
version number to the master to make sure it is up to date. If the versions
match they are off and running. If the versions differ, a message box
informs them to delete their current version and download the latest local to
their desktop. With changes happening every couple of weeks right now, I
would like to create a macro or code that would just delete all the forms in
the current local Db and just copy the new master forms. Does anyone know of
an article or way to do this it would be a big help right now.
Thanks
Chris
store the company data (it is refered to as Master) and a database file
containing local tables, forms, and reports (refered to as Local) for our
employees to copy to their desktop and use. The system alows users to read
and write data when required to the master but function totally seperate in a
local environment. It is much quicker and works fine to date. However, when
a change to the system is required and I need the users to update their
local applications we run into a manual process that I would like to
automate. Right now the first thing the local does is to compare it's own
version number to the master to make sure it is up to date. If the versions
match they are off and running. If the versions differ, a message box
informs them to delete their current version and download the latest local to
their desktop. With changes happening every couple of weeks right now, I
would like to create a macro or code that would just delete all the forms in
the current local Db and just copy the new master forms. Does anyone know of
an article or way to do this it would be a big help right now.
Thanks
Chris