J
JamJar
I have inherited a database used by around 40 people on a daily basis for
input/amendment and review of instances of client contact. This form is
linked to a main table, with all fields having their control sources in that
table.
There is an embedded sub form, based on a second table which displays, and
is used to capture the account numbers relating to the specific instance of
client contact, so there can be multiple accounts per contact.
The problem is that the second of these tables (and related sub form)
becomes locked, so anyone attempting to create a new record (editing existing
records is fine) experiences a momentary hanging of access, then is told
“Could not update; currently lockedâ€.
If I request all users to log out of the package the lock will be removed.
The form is set to No Locks, so I am not sure why this is happening in the
first instance. The DB has very little security, so it is possible for users
to access tables and forms directly, however all users are non technical and
assure me they are using nothing but the form.
I have little experience of forms of this nature in Access, being more an
Excel type, can anyone help?
Thanks in advance, James.
input/amendment and review of instances of client contact. This form is
linked to a main table, with all fields having their control sources in that
table.
There is an embedded sub form, based on a second table which displays, and
is used to capture the account numbers relating to the specific instance of
client contact, so there can be multiple accounts per contact.
The problem is that the second of these tables (and related sub form)
becomes locked, so anyone attempting to create a new record (editing existing
records is fine) experiences a momentary hanging of access, then is told
“Could not update; currently lockedâ€.
If I request all users to log out of the package the lock will be removed.
The form is set to No Locks, so I am not sure why this is happening in the
first instance. The DB has very little security, so it is possible for users
to access tables and forms directly, however all users are non technical and
assure me they are using nothing but the form.
I have little experience of forms of this nature in Access, being more an
Excel type, can anyone help?
Thanks in advance, James.