can't update record locked.....

[lipin]

I have an application that multiple users are entering data into. It is a split DB. On one pc I will get an error: "Couldn't update, record is locked by Admin on machine LKWTHN025909"

WHY. I could understand if the user was trying to go back to a record that another user already had up on the form, but it happens when I first start the application and try to enter data into the first textbox on the form. I hit the data I want to enter into the 1st textbox and without hitting enter or tab, it goes to hourglass and error pops up. How do I fix this?

Thanks,
lipin

 

[jfgambit]

In the Properties of the Form check the Record Locking Properties, is it set to No Locks??

 

[lipin]

still stuck

I have the properties set to no locks. And IT guys moved Db to a new drive and set same permissions for all the users.

But still get the error "couldn't update locked by user on machine...."

Any other ideas?

 

[The_Doc_Man]

"Couldn't update, record is locked by Admin on machine LKWTHN025909"

What jumps out at me first thing of all is the user name. This person opened your database without going through the workgroup. This means the person probably has the right to open the database in exclusive mode. And that permission would make a vast difference in the way things are opened. So I would agree with Pat that this is at base, a permissions problem.

Search this forum for a couple of my other posts on the topic of security setup. I have given the steps to secure a database more than once to prevent exactly this problem.