Refuse Entry to Record if Already open

[Ajwebb]

Hi all,

Was wondering, is it possible to refuse entry to a record if it is already open on another machine.

Don't want to use Lock Edited Records as i don't want anyone to be able to get in to the record in the first place.

My Database is made up of forms without any subforms and navigated through with command buttons only.

Have looked on the Web and can't seem to find that much which can help me.

Thanks in advance for any help

Anthony

 

[KenReay]

Hi

Sorry but to me:

"Don't want to use Lock Edited Records as i don't want anyone to be able to get in to the record in the first place"

makes no sense,

you mean you want only 1 user at a time to be able to access (or update?) a record, or you want no users to be able to access (or update?) it?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ajwebb]

Hi Ken,

Sorry about that, bit of a contradiction in terms. What I meant was, as you said, one user at any one time to be able to access or update a record.

Regards

Ant

 

[KenReay]

Hi

To make it so that only one user can edit, set locking type to pessimistic

I am not aware of any 'builtin' means to prevent to (or more) users accessing the same row. The only thing I can think of which is builtin is to open the TABLE exclusively, but that is probably too drastic for you needs

Out of interest WHY would you want to do this?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ajwebb]

Thanks for replying Ken,

The problem i am having is i have set the Record Locks to Edited Record, but if someone goes into the same record, neither changes are saved.

I thought by preventing people going into the same record, this would prevent this from happening.

However i am unsure of how i would set the Locking Type to Pessimistic.

Do you know of a more suitable way.

Regards

Ant