Front end updates

[AJ]

I apparently am lost somewhere in translation...What the situation is;
backend is on server at office with some users with front ends at the office
also. We are implementing 6 laptops to be used by users in the field. The
frontend on the laptops is going to be used for "read-only", just to view
info, no "new" info is going to be entered in the field. The laptops will be
brought into office at night and plugged into the network. What I am needing
to do is some type of coding so the laptop users can click on an command
button to update the tables on the server to their front ends. Basically
update their copy with the info the office staff entered for the day. Or will
this procedure happen automatically when they plug into the network..? Any
suggestions, articles or hard hammer(to hit myself with) would be
appreciated. I am going in circles. Again, the front ends on the laptops will
not have any new info to move to the backend, they will just need to update
their linked tables with the new info from the backend...

Thanks,
AJ

 

[Arvin Meyer [MVP]]

Rather than a coded solution, I'd simply copy the back-end, and if
necessary, the front-end to the laptop overwriting what's there. I'd also
make a copy of the back-end before it's done to make sure the users copy it,
rather than copying a possibly open file, or worse accidentally moving it
off the server.

If the front-end is changed, the tables may need to be relinked. For that
you might find this utility handy:

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

 

[AJ]

Thank you so much. I new there had to be something I was missing. I didn't
think about copying the backend to the laptop. It makes sense. Thank you for
your time.