unbound form in multiuser environment

[djkoon]

It is multiuser environment question.

I have an Access application front end on five user’s machines
and data mdb on backend in share drive
I’m using unbound form
Is there any easy way I can prevent users from accessing a record on a form if somebody else already has it open? I.e. a message box popping up saying "Another user is looking at this record right now, come back later."?
Does Any one have any type of solution or code ?
I will appreciate .
thanks

 

[PaulF]

check out this thread (found using the search function of this website)

http://www.tek-tips.com/viewthread.cfm?qid=79802

PaulF

 

[djkoon]

I'm interested in working with unbound form

 

[earthandfire]

Don't use Dim in the Immediate Window - the following works in the IM:

Stg = "202;555;344;298;472"
Ary = Split(Stg, ";")
for a = 0 to ubound(ary) - 1 : ?ary(a) : next

 

[earthandfire]

Sorry all, my previous reply should have gone to :

thread702-1037728

I don't know how I got it in here.

 

[djkoon]

not this was not the question
please read my question