Record currently locked message

[Guest]

I am using Access 2003 and have set up a database on a server.

Users login to the database to do data entry they stay loged in all day.

There are aprox 25-30 users each using the same data entry sheet.

The data entry form is made up of 2 forms the main form is not used for data
entry it is used to retrive the data in the subform if any exists.

Users then use the sub for to add new entries into the database.

The both forms are based on quries.

I am NOT using a front end back end model

The Problem

The forms will work fine for a while (some times days) then for no reason
you will keep getting Record currently locked messages.

Does anyone know what may be causing this problem, if so do you know of a
solution ?

Any assistance would be great >

 

[Joan Wild]

Users login to the database to do data entry they stay loged in all day.

There are aprox 25-30 users each using the same data entry sheet.

I am NOT using a front end back end model

I strongly suggest that you change this. 25-30 users all using the same
frontend all day long is a recipe for corruption. It isn't difficult to do.
There are tools you can use to update the users' frontends when you make
changes - eg. http://www.granite.ab.ca/access/autofe.htm

 

[Pringle9984]

You're not using a frontend/backend

Do you mean that you have a single MDB which contains both the dat
and all the forms, queries, etc and all users access this single MD
file over a network

If this is the case I'd highly recommend splitting the database - it'
not that hard and vastly improves performance (make a copy of th
original first just in case)

Ideally just the backend should be located on the network and th
frontend should be located on each user's individual computer
though I can't be certain if this will solve your problem I used t
have similar problems when there were multiple users all running
single copy of the FE.

 

[Guest]

Thanks Joan,

I was hoping that i would not have to split the database but it look like
that is the general oppinion, so looks like thats what i will do and see if
that solves my problem. Thanks

 

[Guest]

Thanks, looks like i will be splitting my database and see if that will fix
my problem.