Records Not Updating over LAN???

  • Thread starter Thread starter Jason Willis
  • Start date Start date
J

Jason Willis

I have an A2k Front end / back end database over a LAN.
The frond ends are local copies on the clients and the
backend sits on an NT4 server.

When a record is entered on one client, the record is not
availabe from the form on another client (but is visable
in the table when opened). If a new record is entered on
the second client, it takes into account the
(unavailable) record number that was created on client 1.

I use a combo box to locate records on the form and when
I try to look up afore mentioned record, the combo box
can see the record number but the record that is
displayed is the first record in the dataset, in other
words the record number displyed in the combo box is not
found???

Could this be a locking or a requery/refresh problem?

If the form is closed, the record is then available.
 
This is a requery situation. If you requery as you save or when you move to
a new record, you'll see the recently entered record. What won't happen is
an automatic refresh of each client. You'll need to do it manually if it is
important to you. Think of what happens when you look at a web page. The
data on that page is static and you'll lose it if you back up. With Access,
you don't lose the data by backing up, but you don't see it without
requerying the form. Actually, I don't know of any application where the
server tells the clients that the data needs refreshing.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin

Thanks for your help. You have given me something to
think about. As the problem happens seldom, I will
probably add a requery button for my users to use when
they encounter this problem.

Thanks for your assistance.

Jason Willis
 
Back
Top