Update Tables from Back End to Front end at detection

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I have a be database and several front ends (remote laptops). Let's say the
back end has a table that receives new items every week (2 to 7) and I want
those new products and their info to get to the front end userers. The front
end users hook up to the server containing the items table every other day,
and have the same table in the same format. Is their a way for the server to
autodetect the laptop and APPEND or run an auto append to update the laptop
with the new products?
 
Then you'll need to approximate what replication does. That is much easier
if you only have to push the data from the server to the laptops. You can
build a small app which deletes the back-end (or both front and back ends)
and replaces them from an app on the server.

If it's both ways though, it becomes a bear. All tables must have a
timestamp and you'll need to update the server with data which is later from
the laptop. Then you'll need to copy the data from the server. You'll need
to do it twice, because each other machine must do it to get the latest on
the server.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Andrew said:
OOPS, Everthing is running on ACCESS 2007
Click to expand...
 
Back
Top