Re: Multiple Users

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
you can consider using record locks - if one use editing record - other will have to wait when he finish
Look at RecordLocks property of a form

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Noemi" <Noemi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4FA80BB4-A595-402A-932B-D59E8292785E@xxxxxxxxxxxxxxxx
Hi
I have a database which has a temp table that is bound to a form.

When one person opens the form and updates the fields which are bound to the
temp table there is no problem

However

When there is 2 people using the form then there is a error for one advising
something along the lines that there is someone already using the table
therefore you can either save to clip board or cancel.

I am hoping that more than one person can use the form at the same time.

Any suggestions please.

Thanks
Noemi

.