Multiple Users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

They cannot, certainly not if they must share the same temp table.

The solution is to split your database - a very good practice in any case! See
Tony Toews' database splitting description at
http://www.granite.ab.ca/access/splitapp/ for details.

Basically, all of the permanent tables would be in a shared "backend"
database; each user would have their own copy of the "frontend" containing the
forms, reports, queries, code and temp tables.

John W. Vinson [MVP]
 
Back
Top