How do I allow a form to only be opened once in a network environe

[Guest]

I have a database that I am designing. It will have mutiple users that may
be able to access the database from different computers over a network.

How do I keep users from opening a form that is already open. This presents
a data security issue for the database.

 

[Tony Toews]

I have a database that I am designing. It will have mutiple users that may
be able to access the database from different computers over a network.

How do I keep users from opening a form that is already open. This presents
a data security issue for the database.

What kind of data security issue?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Joseph Meehan]

I have a database that I am designing. It will have mutiple users
that may be able to access the database from different computers over
a network.

How do I keep users from opening a form that is already open. This
presents a data security issue for the database.

Access should be fine with it. What kind of security issues are you
talking about? Do you mean data corruption? If so the answer is to split
the database.

 

[Guest]

The issue is this. When user#1 opens a form and begins to input data, then
user#2 opens the same form....they cannot input data into the same table at
the same time due to memo box constraints. User#1 will be inputing data into
Text1 when User#2 opens the form. Then User#2 will attempt to input data but
will not see the data that User#1 has input into the Text1 field.

I am afraid that there will be overwriting of data. What I would like to do
is lock the form are keep it from opening when another user has that form
open.

 

[Joseph Meehan]

The issue is this. When user#1 opens a form and begins to input
data, then user#2 opens the same form....they cannot input data into
the same table at the same time due to memo box constraints. User#1
will be inputing data into Text1 when User#2 opens the form. Then
User#2 will attempt to input data but will not see the data that
User#1 has input into the Text1 field.

I am afraid that there will be overwriting of data. What I would
like to do is lock the form are keep it from opening when another
user has that form open.

That should be handled by Access record locking. There are several
options for record locking so check the help file to determine what fits
your situation best.

Record locking is required to prevent stepping on someone's toes. As I
recall Access uses page locking and there may be more than one record on a
page so don't be surprised when it locks more than one record at a time.

Record locking is transparent until someone tries to save a record that
was already changed by another user and Access then alerts the second (or
third etc.) user that the record has already been changed and offers
choices.