How to lock a record from table I want not lock a record from a form

[Taken]

hello every body
i have a question, I need to lock one ligne in a tabel, is it possible for Access 2010 ?
thank's for your response

[jimatqsi]

Taken,
Welcome to Bytes. You'll find a large number of eager helpers here, but you'll have to do your part to present a good explanation of what you want. Please expand on what you said, because it is not very clear what purpose you are trying to accomplish.

Is this a permanent "lock" or during some brief period? If so, what is that period defined by?

Jim

[Taken]

thank's jimatqsi
I work for an application Access VBA 2010 the application have back end and front end, 5 users the problème is:
I have two tables original and Bis, the Original table contains one line Identity and the Questions and there Responses.
the tabel Bis Contains a temporary line (they will be delete after click on bouton) the questions and Responses, to permit for a users to edit data and write Responses.
I want When I click on button to save edit, the line identity from tabel Original will be locked
thank U fore your help

[Rabbit]

Why have a temp table where they edit the record separately from the original?

[Taken]

hello Robbit thanks for your response
the temp table is local for each user, it permit to not get the dirty data in the original table. all records will be delete from the temp table for each edit

[Asmat]

By This Section
You need to make another form, that is lock
and only few row or field can be for General Users

Like
User Id _______
Search by Name _______
Date

[Taken]

Thank you Asmat for your response
I want just to know how can I lock one record from table on vba access.
I tries
Set rstQR = New ADODB.Recordset
Set conn = New ADODB.Connection
Set conn = CurrentProject.Connection
rstQR.Open "SELECT tableName.ID, tableName.NbrQuestion FROM tableName " _
& "WHERE (((ID)=" & Me.ID & ") AND " _
& "((NbrQuestion)=" & Me.NbrQuestion & "))", conn, adOpenUnspecified, adLockPessimistic, adCmdText

it work but dont lock the record showed on SQL statment

[jforbes]

You can't lock a record for edit in Access except for a temporary lock while a SQL process is taking place. Once the SQL process is completed, the lock is released. It's not intended to last more that a second or two.

Usually, in the scenario you are describing, a flag or status field is added to the Table to put a "Soft Lock" on the Record. Then code is added to the Forms to either set and reset the Allow Edits and Allow Deletions properties of the Form or enable or disable buttons that launch the Editable Forms.

[Taken]

Yes jforbes that's what I need ! à temporary lock but juste for one record from tabel (back end) not from form (front end).
but I don't know if it's possible ??
if it is possible I don't have any Idea for how can I do it.
I know how to lock tabel but not just a record from that table
best regard

[Rabbit]

You can't "hard" lock a table or row in Access. You will have to use a more robust database backend if you want to do that.

You can only code your own "soft" lock that the user can get around by opening the table directly.

[Taken]

Thank's Robbit
My problem is How to specifate one record from table to lock it ?
I want to lock juste the record specified not all the table

[Rabbit]

Add a field to the table that says whether or it it's locked. You set it when you want to lock or unlock it.

[Taken]

Thank U Rabbit for your response. sorry for my absence.
I want to know what kind of Number permit me to lock one record
in set recordset=currentdb.openrecordset("Select...", Type, Option, Lockedit)
Exemple: 2, 512,2)
best regard

[Taken]

Hello every body
I get the solution
(2, 2, 3)
but the problem is that the first user is blocked :'(
I want to lock for the second user

[Rabbit]

The recordset options will block everyone except the recordset.

[Taken]

my probem is when I test with two form, with loop an doevents for each user, on click on button, the edit of the first user (first click on button) will not be saved. the edit of the second user will be saved

[Rabbit]

That's odd. Try 2,1,2

[Taken]

That's it Robbit thank U so mutch,

[Rabbit]

No problem, but you should be aware that the lock lasts only as long as the object. It won't keep the lock if the user wants to come back to the record later to finish up.

[Taken]

Another Problem
2, 1, 2 lock all the table, my aime was to lock one record
2, 2, 3 lock one record but if two users clic for the same record
the edit of the first user will be ignorent

[Rabbit]

At this point, I don't know which combination is going to work, you could try all the possible combinations until you find the one that does.

[Taken]

Ok thank you Rabbit, when I find the solution I'll post it