Is Record Open

  • Thread starter Thread starter Lee-Anne W via AccessMonster.com
  • Start date Start date
L

Lee-Anne W via AccessMonster.com

Hi,

can anyone please point in the right direction for the problem i have below.

i have a multiuser database and when 1 user opens the form to edit a record i
want to be able to show a message box if another user tries to view/edit that
same record that will prevent the form from opening.

of course when user 1 has closed the record user 2 can then open it.

any help ...

thanks
Lee-Anne
 
Access does not expose this information to you.

It would theoretically be possible to use the Current event of a form to
write a record record to a logging table, and the Close event of the form to
indicate they've gone. Doing this for all users would involve considerable
extra network traffic and a fairly high chance of write conflicts as many
users scroll records.

If you are only interested in when a user begins editing the record (not
just viewing it), the logging form's Dirty event would be much better.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top