Ensuring front end update

  • Thread starter Thread starter Jake F
  • Start date Start date
J

Jake F

I have a split database and am having the users copy the file to their
computers. When updates are made, I want to guarantee that all of them
recopy the file. As people are a creature of habit and being used to the old
file and already having the old file I need to make sure they have to copy
the new file. So far my only method is to change the name of the BE file so
that when they try to enter the database they receive an error that the
tables are not found. Is there a more user friendly method out there or even
replacing that error with "This database has been updated and the most
current version is needed to be obtained..." I want to avoid any system
errors that will confuse people and then create more questions for me.
 
On Thu, 11 Sep 2008 06:45:02 -0700, Jake F

Check out Tony Toews website. He has an updater utility that can keep
everyone at the latest version.

-Tom.
Microsoft Access MVP
 
Jake F said:
I have a split database and am having the users copy the file to their
computers. When updates are made, I want to guarantee that all of them
recopy the file. As people are a creature of habit and being used to the
old
file and already having the old file I need to make sure they have to copy
the new file. So far my only method is to change the name of the BE file
so
that when they try to enter the database they receive an error that the
tables are not found. Is there a more user friendly method out there or
even
replacing that error with "This database has been updated and the most
current version is needed to be obtained..." I want to avoid any system
errors that will confuse people and then create more questions for me.
Click to expand...

Use a batch file. Users' shortcuts point to the batch file which resides in
a read-only folder on a server along with a copy of the FE. The batch file
copies the FE to the users' local drives and then opens it. All you have to
do is make sure you have the latest version of the FE in the read-only
folder.

Keith.
www.keithwilby.com
 
This utility looks like it'll work great. Will I need to have admin control
over all the users though? I don't work in the IT dept so I'd have to get
their permission for it or have them run the utility if so. But if I can run
this utility, it will save me a lot of hassle and time because like the
website says, I'm not lazy, just "selectively industrious".
 
Hi Jake,

No special requirements that I can recall, Jake, except access to the files
(the utility and your front end) on the server. Basically, your users (and
you) need permissions to the folders you are using, which you already have
(at least on the folders you use currently....since you said you already were
having users copy down the updated version of the front end).

Of course, read through the stuff at that link and any related material. I
haven't had to mess with it for a good 18 months now which is around the time
I started using it I think.

Good luck!
CW
 
Jake F said:
This utility looks like it'll work great. Will I need to have admin
control
over all the users though? I don't work in the IT dept so I'd have to get
their permission for it or have them run the utility if so.
Click to expand...

Tony's website states that it modifies the registry so I imagine you will
need admin rights to the PC. I'm not sure why the registry has to be
modified. The batch file method needs no such permissions.

Keith.
www.keithwilby.com
 
Back
Top