Lock underlying table from other users

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

Guest

I have an application in a multiuser environment that includes a utility form
used to develop certain fees for a certain dynaset. The form is bound to a
table, the contents of which are temporary. The form is used to add data to
the table but, when the form is closed, the data is automatically dumped.

I would like other users to be locked from entering data by this form after
the first user opens it. Is there a way to accomplish this?
 
Ken Smith said:
I have an application in a multiuser environment that includes a utility
form
used to develop certain fees for a certain dynaset. The form is bound to a
table, the contents of which are temporary. The form is used to add data
to
the table but, when the form is closed, the data is automatically dumped.

I would like other users to be locked from entering data by this form
after
the first user opens it. Is there a way to accomplish this?
Click to expand...

Why you would want to delete all data when the form is closed is beyond me
but if you want to limit the app to a single user then have it opened
exclusively. If you want the first user to open the form to get write
access then you need to store the fact that someone opened the form in a
table, then test that table and set the form's properties accordingly in the
On Open event.

Regards,
Keith.
www.keithwilby.com
 
IMO you seldom need temporary tables in a well-designed application.
(Note: I said "seldom" - not "never"!)

If you explain more about why you need the temporary table, someone
could maybe provide a better solution that did not need that table at
all.

HTH,
TC
 
Back
Top