Locking Access Database

[Awadh Kishore]

I have a table where all serial no. are kept. Suppose one of them is Bill_serial_no. when two users are simalteneusly making bills the Bill no is same for both the bills in the bill table, but the Bill_serial_no gets incremented by 2. I have tried the following code :

dim cn as ADODB.Connectio n
dim rs as ADODB.Recordset

sqtxt="select * from SerialTable"
set rs=New ADODB.RecordSet
With rs
.CursorType = adOpenDynamic
.LockType = adLockPessimist ic
.ActiveConnecti on = cn
.Open sqtxt
End With

Please Help Me.

[debasisdas]

is SELECT the only SQL command that you are using ?

[Awadh Kishore]

is SELECT the only SQL command that you are using ?

Yes it is. If there is any thing else that could be used then please suggest me.
thanking you.

[QVeen72]

Hi,

Post the Saving Part of your Code..

Regards
Veena