Error Message in the Form

[vanny]

Hi all,

Maybe someone can help me. I have a system, that is usually used by 10 people. All of a sudden once, when a user was using it to input some data, it gave the following error:

Cannot Update. System is locked.​

However, I'm sure that the system was not locked; at the time that the error msg popped up.

Once I instructed all users to log out - so that I can test- no error msgs were given.

Any ideas of what could have been.

Thanks

 

[heedaf]

Lock

If this problem happens again look at the lock file and it will tell you who it was locked by. The problem might have been that 2 users were trying to change/modify/update the same table.
DeWayne

 

[MStef]

Try this;
All users must have ALL PERMISSIONS on the directory where your MDB is, (on server).

 

[vanny]

So even though the database is split as back and front end; users cannot update the same table at the same time??

 

[MStef]

Try next;
Open mdb window.
Click on Tools, Options, Advanced

Default open mod (select Shared)
Default record locking (No locks)
Open database using record-level locking (select it).

Make it on BE

 

[boblarson]

So even though the database is split as back and front end; users cannot update the same table at the same time??

And each user has a separate copy of the frontend on their machine (not all accessing the same frontend on the server)?

 

[vanny]

Hi MStef, thanks for your suggestions.

I have actually all settings set that way in my mdb. BUt still it gave me that error

 

[MStef]

I have no idea.

 

[vanny]

The back and front end database is stored on the server, and all users have access to the server.

 

[boblarson]

That's your problem then. In a frontend/backend situation every user MUST have a copy of the frontend on their machine and not be accessing it from the server.

Read here for more info:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

Also, I have a tool that will enable auto updating for your frontend so you don't have to worry about users having the latest copy. Be sure to read the documentation that is available on the same page:

http://www.btabdevelopment.com/main/AccessTools/tabid/78/Default.aspx

 

[vanny]

Thanks a lot for your suggestions.

I will definately take a look through your notes.

Thanks once again, much appreciated