how to work with net

W

wehadyxp

*i need to make database work in net what setting i need to make man
user used it but the problem when any user open invoice and anothe
user open in this moment this invoice the two users write in on
invoice how solve it and setting
 
J

John Vinson

*i need to make database work in net what setting i need to make many
user used it but the problem when any user open invoice and another
user open in this moment this invoice the two users write in one
invoice how solve it and setting *
Click to expand...

Could you please rephrase the question? It is not clear what you are
asking. If two users open a form to the same invoice at the same time,
what do you WANT to happen? If the first user sets the total cost to
$125 and the second use sets the total cost to $75, on the same
invoice, at the same time, what would you want Access to do?

John W. Vinson[MVP]
 
W

wehadyxp

dear john
i need 1 user only open invoice form and if another user open sam
invoice at at the same time cannot open it and open new invoice
the problem happed when 2 user used one record at same tim
 
J

John Vinson

dear john
i need 1 user only open invoice form and if another user open same
invoice at at the same time cannot open it and open new invoice
the problem happed when 2 user used one record at same time
Click to expand...

Again:

What do you want to happen when two users open the same record at the
same time?

Access will give you an error message.

You can set the Database Options to "pessimistic locking", which will
give the second user an error message when the first try to open the
record; or leave it with the default "optimistic locking", which will
only give the error message when the second user tries to change the
data in the record.

You CANNOT avoid getting an error message, because two users editing
the same record at the same time *is* an error condition.

John W. Vinson[MVP]
 
W

wehadyxp

thanks a lot but i want change this massage and writer another massag
like " please another user used this invoice now"
how change massag
 
Top