Update Tables from Back End to Front end at detection

[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?

 

[Jerry Whittle]

In a word: replication. Check out help on it.

 

[Arvin Meyer [MVP]]

You can use Replication in versions of Access earlier than 2007:

http://support.microsoft.com/kb/282977/en-us

 

[Andrew]

OOPS, Everthing is running on ACCESS 2007
--
Andrew
H.W. Lochner

You can use Replication in versions of Access earlier than 2007:

http://support.microsoft.com/kb/282977/en-us

 

[Andrew]

OOPS Everything is running on ACCESS 2007

 

[Arvin Meyer [MVP]]

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

OOPS, Everthing is running on ACCESS 2007