Multi-User - CAN ANYBODY HELP

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

Guest

I have a be/fe application, everything works great but have one issue. When
one user is in a recordset (same form) that another user pulls up, the
original user's data shows #deleted. My users have their front ends on their
individual desktops and the backend is on the server. I have the options set
to No Locks, Open databases using record level locking.

Can anyone help me?

Thanks in advance.
 
Bonnie said:
I have a be/fe application, everything works great but have one issue. When
one user is in a recordset (same form) that another user pulls up, the
original user's data shows #deleted. My users have their front ends on their
individual desktops and the backend is on the server. I have the options set
to No Locks, Open databases using record level locking.

Can anyone help me?

Thanks in advance.
Click to expand...

Bonnie,

First, the obvious: maybe the other user really is deleting some of the
original's data. #deleted will show in those instances.

Second, and maybe not so obvious: even though your backend will handle
multiple users, maybe there are design limitations in your frontend
which restrict the number of users on your database.

An example would be a single temp table that is dedicated to a single
user. So, when the first user logs on, they 'own' the whole table (it
gets deleted/initialized for their use). But, when the second logs on,
they also 'own' the table, deleting any work in progress by the first.

Two solutions for this: make the temp table local to the frontend, or
key the temp table with the Login ID of the user.

-Ken
 
Hi Ken,

Thanks for replying. No, we tested, the other user was only opening the a
form and selecting the same data set. There are no design limitations or
temp tables either. Do you know if I can change a setting to lock the
records that one user has on screen (even though not yet editing)?

Thanks.
 
Back
Top