Could not update; Currently locked

[SiGill]

I have a database which 8-10 users have access to, I have made it so they only have access to certain forms. I am the only only to have access to the background information.

Just recently every now and then they start to get a message which says "Could not update; Currently locked" I have had a look through the forum and I am unable to see anything that will help me rectify the problem.

Any help would be appreciated.

 

[ghudson]

Is your database split with each user having a copy of the front end installed on their PCs harddrive and all the front ends linked to one backend on a server?

 

[SiGill]

Each user has access to the main database, the database isn't split. I have just made it so they have access only to certain forms

 

[SiGill]

I am wondering as it only seems to happen on one particular form when its opened, Could it be that I have code in the On Load area and in the On Activate area. And that they are trying to do their bits at the same time. In the On Activate Area i have DoCmd.Maximize

 

[SiGill]

Also, another thought sorry. I had it set to Compact on Close. Could it be that someone is closing the database, its trying to compact which is causing issues for the others?

 

[boblarson]

For multi users you NEED (not should, but NEED) to split the database and give each user a copy of the frontend. If you don't you soon will be complaining of corruption issues. In your situation, it is not IF it will corrupt, but just a matter of WHEN it will do so.

Read this as it is important to the situtation.