Tools to Automate importing/exporting objects?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello-
We are using replication at our site. We have a design master on the server
and 12 partial replicas with 12 front ends. When we have a change to a form
or query, we want to be able to automate the replacement of that object in
each of the 12 front ends that link to the partial replicas. Does anyone
know of a tool or add in that will do this? I've checked with FMS and they
don't have a utility that does that. Or - does anyone have a better idea of
distributing those changes to all the databases? Thanks.
Debbie
 
Here is a site that will give you an idea on how to keep fe's up to date.
There are other versions out there as well. The basic concept (in case you
want to write your own) is to have a table in the fe that has the current
version number in it. Then in your startup code, compare that version to a
table in the be that has the most current version number. If the fe version
is not the same, the then fe starts up another mdb that does nothing more
than present a message to the user that it is updating and copies the new fe
from the server and closes itself. When the updater is finished copying the
new fe, it starts it up.
Here is the site:

http://www.granite.ab.ca/access/autofe.htm
 
Klatuu,
Thank you for the info. I did see that site in my research. The only
problem is I don't want to replace the enter front end (which seems that this
is what these utilities do), because I have hardcoded path statements back to
the partial replica plus I would then have the relink the tables to the back
end. I think I may have an idea using the same concept as the developer in
the link you sent me. Thanks alot.
Debbie
 
If you use UNC paths, then you can link the new front before you deploy it.
It will then already have the correct links.
 
Back
Top