Change the status of a record

[vagelisr]

Hi to all

I have a multiuser 2003 access database (at least 4)
In my main record when i press update they open a new form with the specific record.
Before change everything in the update screen i see a black right arrow and when i change everything the black right arrow change with a pencil

When me record change to pencil my database lock the record and everything is OK.

I want to knew if is possible to change the status of the record in the form open or form load

Thanks and regards.

 

[JamesMcS]

When you say status, you mean lock the record, right? By default, Access uses pessimistic locking, so that when the record is open on the form, nobody else can edit it.

 

[vagelisr]

First of all thanks for your reply!!!!!!!!!!!!!!!!!

In my case if i did not make any changes they didn't lock the record

Did you have any idea why??
If a change anything in the record then the will lock the file (they change the right arrow to a pencil)

Thanks for your time!!!!!!!!

 

[JamesMcS]

Have a read of this, see if it helps:

http://office.microsoft.com/en-us/a...ss-database-on-a-network-mdb-HP005240860.aspx

 

[vagelisr]

Thanks again but......

If you see in this article says..
"Edited Records Microsoft Access locks the record you're editing, so no other user can change it."

If you just open the form without starting editing the status of the record is not locking......
This is what i want to do......

Thanks again............

 

[JamesMcS]

Then you might have to do something like having a yes/no field in the underlying table to say "being edited" and set that to True when the record gets the focus.

 

[vagelisr]

i will be relly appreciate if you can be more specific.

Im try to put a yes/no field in my record but when im try to open the same record from 2 diffirent computers i receive an error. (i dont remember the error because wright now i am in my house)

If you have make something similar please post your code.

Thanks again for your time.

 

[JamesMcS]

I haven't made anything like this before. Basically what we're getting at is that we want the record to be edited as soon as the user moves to it, right? So if you have a field that is changed as soon as the user moves to the record (in this case a yes/no field, but it could be anything), the record is being edited and it's locked. Isn't that what you wanted?