If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Locking Records
I want to lock a record on a form if it is open by another user. I have
record locks set to "Record Level Locking". However it does not lock anybody out. If I set to "All Records Locked", it works but it is not what I want. What am I doing wrong? |
#2
|
|||
|
|||
Locking Records
It all depends what you mean by "lock anybody out".
Running SQL can always defeat Access's record locking specifications. There is a lot of information about 'record locking' in Access Help. Dorian "MU86" wrote: I want to lock a record on a form if it is open by another user. I have record locks set to "Record Level Locking". However it does not lock anybody out. If I set to "All Records Locked", it works but it is not what I want. What am I doing wrong? |
#3
|
|||
|
|||
Locking Records
When one user is editing a record, I don't want another user to be able to
edit the same record. -- Mike "mscertified" wrote: It all depends what you mean by "lock anybody out". Running SQL can always defeat Access's record locking specifications. There is a lot of information about 'record locking' in Access Help. Dorian "MU86" wrote: I want to lock a record on a form if it is open by another user. I have record locks set to "Record Level Locking". However it does not lock anybody out. If I set to "All Records Locked", it works but it is not what I want. What am I doing wrong? |
#4
|
|||
|
|||
Locking Records
On Mon, 5 Dec 2005 14:18:02 -0800, "MU86" wrote:
When one user is editing a record, I don't want another user to be able to edit the same record. That is Access' default behavior. You don't need to do ANYTHING to get that. The downside is that the second user doesn't get a warning until they attempt to save the record. John W. Vinson[MVP] |
#5
|
|||
|
|||
Locking Records
"MU86" wrote in message ... I want to lock a record on a form if it is open by another user. I have record locks set to "Record Level Locking". However it does not lock anybody out. If I set to "All Records Locked", it works but it is not what I want. What am I doing wrong? You need to set this for the particular form. IN the "data" tab, set the locks to edited record. If you set the above, then any other user who tries to edit the record will NOT be able to. If you leave it to no-locks, then users will get the message about the "other" user having changed the record... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#6
|
|||
|
|||
Locking Records
It still is letting access to the "open" record with "record level locking"
turned on. One clarification....mulitple users are using the same form if it makes any difference. -- Mike "Albert D.Kallal" wrote: "MU86" wrote in message ... I want to lock a record on a form if it is open by another user. I have record locks set to "Record Level Locking". However it does not lock anybody out. If I set to "All Records Locked", it works but it is not what I want. What am I doing wrong? You need to set this for the particular form. IN the "data" tab, set the locks to edited record. If you set the above, then any other user who tries to edit the record will NOT be able to. If you leave it to no-locks, then users will get the message about the "other" user having changed the record... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#7
|
|||
|
|||
Locking Records
"MU86" wrote in message
... It still is letting access to the "open" record with "record level locking" turned on. One clarification....mulitple users are using the same form if it makes any difference. Yes...two users can still open to the same record. Who ever starts editing the record get the lock..and any other user will see "lock" icon in the record selector if they try and edit the record. So, the actual lock does not occur by just viewing the record, you have to actually "dirty" the record. So, only one user will be allowed to edit..but others can still view...or navigate "past" this record without receiving some nag message. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
#8
|
|||
|
|||
Locking Records
Thanks. I see that it is preventing another person from editing the record.
How can I have a message pop-up if the record is locked? -- Mike "Albert D.Kallal" wrote: "MU86" wrote in message ... It still is letting access to the "open" record with "record level locking" turned on. One clarification....mulitple users are using the same form if it makes any difference. Yes...two users can still open to the same record. Who ever starts editing the record get the lock..and any other user will see "lock" icon in the record selector if they try and edit the record. So, the actual lock does not occur by just viewing the record, you have to actually "dirty" the record. So, only one user will be allowed to edit..but others can still view...or navigate "past" this record without receiving some nag message. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access locking a range of records | Wayne | General Discussion | 3 | October 20th, 2005 09:57 AM |
Best strategy for MU data entry form with multiple record subform | AliKwok | Using Forms | 15 | August 25th, 2005 01:16 PM |
forms and records locking | nikos a via AccessMonster.com | Using Forms | 2 | August 11th, 2005 01:36 PM |
Locking records after 3 weeks (or x amount of time) | Susy | General Discussion | 8 | April 13th, 2005 05:16 AM |
Attn Sprinks- Not duplicate insert records | babs | Using Forms | 1 | December 13th, 2004 06:25 PM |