Record currently locked message

G

Grmityler

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 >
 
J

Joan Wild

Grmityler said:
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
Click to expand...


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
 
G

Grmityler

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
 
G

Grmityler

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