I am in the process of building a multi user system that I envisage
running of a server with client DB's using linked tables. Is there
anyway to force the client DB's to update these tables at a set period
of time? Or is there a better way to go about this?

Many Thanks
Glyn

If you are running off of linked tables, then every change to records from
those linked tables will be made as a normal record save would be.

For information on setting up a front-end/back-end system, see this link.

http://www.granite.ab.ca/access/splitapp/index.htm

--
Wayne Morgan
MS Access MVP


"Splashout" <splashout1 (AT) yahoo (DOT) com> wrote

Wayne thanks for the response I think i understand you but if one user
makes an update to a record then another user will not see that change
unless they reopen the DB is this correct? It maybe you have already
answered this with the link that i will look at tomorrow if so
appologies for re posting

Go to Tools|Options|Advanced tab. The value you're looking for is the
"Refresh interval (sec):". There is a similar for an ODBC connection. This
will do a refresh, not a requery.

From the help file: "In an Access database (.mdb), refreshing records only
updates the data that already exists in your datasheet or form. It doesn't
reorder records, display new records, or remove deleted records and records
that no longer meet specified criteria. To perform those tasks, requery the
records."

So, changes to existing records will be seen, but new records entered by
other users won't be seen until you do a requery. Also, records that are
deleted or changed so that they no longer fit the filter (if one is in use)
or query criteria (although the changes should show) will still be shown in
the form until it is requeried.

--
Wayne Morgan
MS Access MVP


<splashout1 (AT) yahoo (DOT) com> wrote