Locking Records

[Michael]

I am using a split database (Access 2002) in a multiuser
environment. Occationally it will freeze up and give a
message saying "Locked record" but then I am unable to
get off of that record. I think what is happening is
that there is a me.refresh on the OnCurrent event and
when a user is updating a record and someone scrolls over
it, it thinks two users are trying to update. Is this a
possibility?

Thanks for any help I can get!

-Michael

 

[TC]

I am using a split database (Access 2002) in a multiuser
environment. Occationally it will freeze up and give a
message saying "Locked record" but then I am unable to
get off of that record. I think what is happening is
that there is a me.refresh on the OnCurrent event and
when a user is updating a record and someone scrolls over
it, it thinks two users are trying to update. Is this a
possibility?

Tough to say without seeing your code.

- What is the actual message? (I doubt it just says "Locked record".)

- On what statement does it occur?

- In wghat way can you not move off the record? Do you keep getting the
message when you try to move off, or do the record navigation buttons
disappear, or does the form stop responding, or .... ?

- Why are you doing a me.refresh in form oncurrent?

TC