hello
I used only codes for connecting to an ms.access table like below :
Global defcon As New ADODB.Connectio n
defcon.Open "DBQ=" + App.Path + "\db1.mdb;defau ltdir=c:\my documents;drive r={Microsoft Access Driver (*.mdb)};DRIVER LD=281;FIL=MS ACCESS;FILEDSN= C:\PROGRAM FILES\COMMON FLIES\ODBC\DATA SOURCE\MS ACCESS DATABASE.DSN,UI D=BB;USERCOMMIT SYNC=YES"
now i want to lock records that one user is working with them for example in update or delete ,that the others can't work with them ..... how can i do it ?
I used only codes for connecting to an ms.access table like below :
Global defcon As New ADODB.Connectio n
defcon.Open "DBQ=" + App.Path + "\db1.mdb;defau ltdir=c:\my documents;drive r={Microsoft Access Driver (*.mdb)};DRIVER LD=281;FIL=MS ACCESS;FILEDSN= C:\PROGRAM FILES\COMMON FLIES\ODBC\DATA SOURCE\MS ACCESS DATABASE.DSN,UI D=BB;USERCOMMIT SYNC=YES"
now i want to lock records that one user is working with them for example in update or delete ,that the others can't work with them ..... how can i do it ?