Update Front End

[Guest]

Hi,
I have search through this forum and could not find exactly what I need.
Could someone please explain in details (coding..etc) how I do about updating
the front end automatically? I have split into FE and BE, I have BE in the
shared folder, and FE is copied into each individual's computer. Right now,
I email everyone to let them know changes were made to the database and they
would copy and paste the new version.

Thank you in advance for you help!

 

[SirPoonga]

There's different ways to do this.

You can use Tony's util
http://www.granite.ab.ca/access/autofe.htm

You could make a version table in your DB that keeps track of current
version of FE and BE. The FE will have coded in it its version number.
Then when the FE starts up it can check if it is the current version.
If not give the user a warning to update and make the FE not usable
somehow.

Kevin

 

[Wayne Morgan]

You may be interested in Tony's solution.

http://www.granite.ab.ca/access/autofe.htm

 

[SirPoonga]

And you can search this newsgroup
microsoft.public.access.multiuser

 

[Joseph Meehan]

Hi,
I have search through this forum and could not find exactly what I
need. Could someone please explain in details (coding..etc) how I do
about updating the front end automatically? I have split into FE and
BE, I have BE in the shared folder, and FE is copied into each
individual's computer. Right now, I email everyone to let them know
changes were made to the database and they would copy and paste the
new version.

Thank you in advance for you help!

I used a version method. The FE version number was hard coded. Each
time it was opened it read the current version in a version table in the BE.
If it was current, no action was taken. If it was not current I had two
possible reactions. One would post a message telling them they were out of
date and they needed to update, the only close button showing was to close
the database, The other action was to display the message I provided on the
BE which would generally tell them they were out of date and needed to
update by a given date or what ever I wanted to tell them. In hind sight, I
would have added an additional option to give them other one time messages
and or temporary messages like outages for maintenance or announces of
upcoming changes.

 

[Larry Daugherty]

Hi Georgia,

Go to Tony Toews's site: http://www.granite.ab.ca/accsmstr.htm and look for
FE Updater.

It's a solution endorsed by many developers.

HTH

 

[Tony Toews]

Go to Tony Toews's site: http://www.granite.ab.ca/accsmstr.htm and look for
FE Updater.

It's a solution endorsed by many developers.

Wayne, SirPoonga and Larry

Thanks for the recommendations and kind words.

Tony`
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm