Lock underlying table from other users

K

Ken Smith

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?
 
K

Keith

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?

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
 
T

TC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top