Record Locking Problem

Guys,

I created a database about 2 years ago with about 30 tables and 60 queries,
with a bunch of forms, and macros, and a whole heap of a lot of VB code. It
was worked excellent until recently.

Here's the problem........

The users are griping about not being able to update records when they are in
the forms. Could the database be getting to large or something?......because
this problem just started recently. It started with just one user at first,
but now it has spread and is affecting everyone else as well. Your thoughts
or ideas would be much appreciate because as you can see I have exhausted all
of mine. Thanks

JG

--
Message posted via http://www.accessmonster.com

re: Record Locking Problem

jamesgrady via AccessMonster.com wrote:
[color=blue]
> Guys,
>
> I created a database about 2 years ago with about 30 tables and 60 queries,
> with a bunch of forms, and macros, and a whole heap of a lot of VB code. It
> was worked excellent until recently.
>
> Here's the problem........
>
> The users are griping about not being able to update records when they are in
> the forms. Could the database be getting to large or something?......because
> this problem just started recently. It started with just one user at first,
> but now it has spread and is affecting everyone else as well. Your thoughts
> or ideas would be much appreciate because as you can see I have exhausted all
> of mine. Thanks
>
> JG
>
> --
> Message posted via http://www.accessmonster.com[/color]

JG
Firstly, bear in mind that when an Access database is open, it is set
for exclusive mode - this means only one user can work on data at a
time.
Secondly, make sure the data is not read only, could be on a CD rom or
even a server with read only access.
Access databases, as far as I am aware, can handle about 2Gb of data.

Hope this helps
D

re: Record Locking Problem

Check the Options to see if All records are locked. If they are then when
one person opens a form, all records of the backing tables will be locked.
Check Edited record. Don't check No locks because this would allow two
epople to edit the same record at the same time and that you don't want. If
Edited record is checked, they cold be trying to update the same record and
Access won't allow that with that option.
If they are using the same .mdb file, this could cause problems. If this is
the case, split your db.
I don't think the size of the db has anything to do with locked records. I
have a db with 60 tables (most with about 2500 records) and over 200 queries
(yeah, I know that's a lot but I built this when I was a novice and it was
done with no coding on my part) that has been running for 6 years now with
multiple users and we haven't had this problem.

jamesgrady wrote:[color=blue]
>Guys,
>
>I created a database about 2 years ago with about 30 tables and 60 queries,
>with a bunch of forms, and macros, and a whole heap of a lot of VB code. It
>was worked excellent until recently.
>
>Here's the problem........
>
>The users are griping about not being able to update records when they are in
>the forms. Could the database be getting to large or something?......because
>this problem just started recently. It started with just one user at first,
>but now it has spread and is affecting everyone else as well. Your thoughts
>or ideas would be much appreciate because as you can see I have exhausted all
>of mine. Thanks
>
>JG[/color]

--
Message posted via http://www.accessmonster.com

re: Record Locking Problem

On 16-Jun-2006, "ComputerJunkie" <dave.cj1506@gmail.com> wrote:
[color=blue]
> Firstly, bear in mind that when an Access database is open, it is set
> for exclusive mode - this means only one user can work on data at a
> time.[/color]

This is not true. A number of users can work on data at the same time, but
you need a little bit of luck. They can't try to save records saved in the
same "page" of data storage on the disk. You have no way of knowing which
records are where, so you have no way to police that. However, as another
respondent said, you can set things so that people can't try to edit the
same record at the same time.

It is true that in order to make design changes you MUST have exclusive
access to the MDB. You don't have to Open Exclusive from the Open File
dialog, but you do have to be the only user in the MDB.

As for data, your chances are pretty good to have no problems. I have
databases that have been in the field for years and have yet to have a
significant problem with simultaneous users editing data.