Update issue

[Guest]

I have a database that is in access that has worked fine for years. Just
recently I encountered a problem. When person (A) on the network create a new
record the other person (B) on the other computer can only see the record in
a find/search. They can't pull up the record (record not found) error occurs.
However, when person (B) exits and restarts access, they can see the record
and pull it up. The only thing I didn't do to this database was create a
front and backend. Could that be the problem? The users just click on the
..mdb on the folder I created on the network. Thanks

 

[Guest]

That's certainly part of the problem. Each user must have a copy of the
front-end on his workstation. The backend must be a linked file on the
server. What you have now is each user with an instance of the data, and that
data doesn't get resolved until the user exits. What's more, you may
experience even greater problems if 2 users happen to edit the same record(s)

If users keep the same form open and on the same record for long periods,
they won't see a refresh of the data. That needs to happen periodically.
Hitting Records Refresh from the menubar should fix that.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access