Prevent users to open same record

[Guest]

Hi,
its my first post, anyways let me come to the point.

i've one table with the information and i've made a form for data entry
actually its for editing data so when they open data entry form they'll find
all information there except the customer's response field which they gonna
update after contacting the customer so the problem is that there are around
8 users updating the same table and what i want is if one user is updating
lets say record1 then the other user shudn't be able to open the same record
or in other words when 2nd user opens the data entry form he should move to
the next record automatically...
i hope i'm pretty clear here n i'll appreciate an urgent reply
thanks for listening me in advance

 

[Guest]

Roy,

One of the great features of Access is that people can work with it
simultaniously. When one is editting data the other can still retrieve the
information.
In asnwer to your question you could try setting the forms property of
record locks and set this to edited record. You don't want to check who is
working on what because you would never know how long users are going to be
editting records. That's what Access tries to solve internally, release
locking when the edditing is done.

 

[Guest]

Roy,

One of the great features of Access is that people can work with it
simultaniously. When one is editting data the other can still retrieve the
information.
In asnwer to your question you could try setting the forms property of
record locks and set this to edited record. You don't want to check who is
working on what because you would never know how long users are going to be
editting records. That's what Access tries to solve internally, release
locking when the edditing is done.

first of all thnx Maurice for your answer, but i already have tried locking
record option and what happened was that when first user opens data entry
form den he sees the first record but when another user opens the data entry
form it gives him a msg that the record is open for edit with different
user...and he cannot move to another record so what i want is that he should
move automatically to a 2nd unopened record if the first record is open with
some1...

 

[Guest]

Roy,

As you mention in your answer this is the hard part because what you are
trying to look and check for is if a record is being editted at a particular
time. That's the unpredictable factor here because you would never know when
the other users are ready with editting their records. So what would be the
checkpoint. My advice in this situation is to rethink the strategy and look
for antoher solution.

You could use various tricks on this one, but I don't know if that's the
desirable situation. You could use a query as the source and add a yes/no
field to the table. In a form you could then use something like open where
the check is false - meaning that if it is opened you'd update the query imm.
by setting the check to true.

But I call this 'plastering' and I think you should reconsider my initial
thought on this one.

 

[Guest]

Maurice, so there is nothing we can do about it? well i'm thinking to use sql
like assign 100 records to each of the user to edit and one thing more i
tried using sql query like (if customer response_field) is null den it will
appear in data entry if its filled with remarks den it will move from data
entry i thought it will help from opening same record by users but actually
when they open the data entry form they call the client first n based on the
customer's reply they fill that field so it takes i guess minimum 1minute to
fill n during that 1min some1 else can open it n call the same customer
again. it will be funny if the same customer is contacted twice n i don have
the timestamp field even to ristrict through the time.. so if you can tell me
in detail about what are the options dat i can use here, i'll be really
appreciating this....n i still do for whatever you've suggested
take care n thnx for your time.