Backend Server , Frontend box (Replica) Trouble w Record locking 1

[karassik]

I am using Access 2000. I split my database and have the tables on the server, and frontend replicas on my users boxes. I have the design master on my box. On Options, I have checked "open database using record level locking" and Default Record Locking to, "Edited Record", but from the Master I can open the same record that another user is modifying. Obviously I can't have this happening. Is there something that I can do differently to prevent this?

I have an event on Form_Open of:
DoCmd.GoToRecord , , acLast
I wouldn't think that this would effect it, but it has been know to happen.

Thanks for any help you can provide.

NK

 

[thornmastr]

No.

As far as Access is concerned nothing bad has happened. Your locking routines, behind the scenes, really do not fire until an update is fired. Say user 2 has record A and while editing it gets a phone call which he answers. It is his boss and the call is going to take a while.

While user 2 is talking to boss, user 1 grabs record A, makes one quick change and updates record. Even though he had it last, his changes go through as he updates first. User 2 now tries to update and he gets the warniung/error message.


Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[karassik]

Thanks,

I guess I ran into a little trouble, when I deleted a file that someone else had been working. This was just a test to see how Access would react. I guess I should probably just get rid of the delete record feature that I put in...

You answered my other questions that I didn't ask as well, so again thanks.

Nishan Karassik