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?

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?

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?

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]

"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

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

"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

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