updating the database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a real time database updation project, When the Main database is being
viewed by the administrator, it does not update the table if any data put
into it from the user.
The data is simply lost.
What is suggested to b done in such situations.
 
First, are you (or the Administrator, or the user) working directly in the
table? Access forms work much better for data entry/edit.

Next, is this database "split" into a front-end (a copy of which resides on
each user's PC) and a (single) back-end (located on a network where all
front-ends can link to it)?

Is anyone (?administrator?) opening the database "exclusively", thereby
preventing anyone else from using it?

If someone tries to update a record in a table being viewed by the
administrator, what message does that user receive to let them know their
data entry failed?

More information, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top