W
Wazza
Hi
One of our clients has raised the above stating that the error "Record
Locked" occurs several times a day in a rather small database that is being
used.
The database has 5 users using a front end, and a single back-end that is
being updated. This is set by linked tables. The front-end is on a network
drive as is the back-end and all users have read/write access to the network
drive.
The problem seems to be occurring with one very particular person. Anytime
this person uses the database, it locks for everyone, however, if he is not
in the office, it seems the database does not lock. The front-end portion
that he uses has been "tested" on several machines, and the same thing
happens constantly.
We have created a "copy" of another users' front-end database and customized
to the problem customer, however, this has made absolutely no difference at
all.
It does seem to be down to a particular query that involves a listbox and
two text fields, where if the list box selection is made, the fields should
update with relevant data. I cannot say if this is always the case
though...as I only saw this Record Locked error once when selecting the field
and have pretty much only heard of all the other times (anything up to 20 a
day)
The database is about 10 - 15 Mb in size.
Maximum 5 users at any one time.
Record level locking enabled.
Open as shared database.
Any ideas from anyone would be really helpful. I did not design the
database, nor am I proficient in Access development, so not entirely sure
where to start.
Many thanks
One of our clients has raised the above stating that the error "Record
Locked" occurs several times a day in a rather small database that is being
used.
The database has 5 users using a front end, and a single back-end that is
being updated. This is set by linked tables. The front-end is on a network
drive as is the back-end and all users have read/write access to the network
drive.
The problem seems to be occurring with one very particular person. Anytime
this person uses the database, it locks for everyone, however, if he is not
in the office, it seems the database does not lock. The front-end portion
that he uses has been "tested" on several machines, and the same thing
happens constantly.
We have created a "copy" of another users' front-end database and customized
to the problem customer, however, this has made absolutely no difference at
all.
It does seem to be down to a particular query that involves a listbox and
two text fields, where if the list box selection is made, the fields should
update with relevant data. I cannot say if this is always the case
though...as I only saw this Record Locked error once when selecting the field
and have pretty much only heard of all the other times (anything up to 20 a
day)
The database is about 10 - 15 Mb in size.
Maximum 5 users at any one time.
Record level locking enabled.
Open as shared database.
Any ideas from anyone would be really helpful. I did not design the
database, nor am I proficient in Access development, so not entirely sure
where to start.
Many thanks