Access 2000 Record Level Locking

[Muzzy]

Hey All,

I'm currently developing a multiuser application. When I open two instances of the same record on a form on different machines, so one record is read/write and one record is locked I get the message 'You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later'. Even though this message pops up it still lets me save my changes. How do I disable or handle this message?
I don't know why I'm getting ti anyway with having the right record level locking settings!

Cheers

Muzzy

 

[Newposter]

You should get that message. Although two or more users can have the database open, only one can have R/W access to a record while the other views it.

If it allows you to write, could it be that the other user has since moved to another record and released the one you were editing? Newposter
"Good judgment comes from experience. Experience comes from bad judgment."

 

[Muzzy]

No, because I have implemented record level locking which locks a recored that has been opened for editing by someone else. The person who has it open as write should not get this message. I think!!!!

Cheers