Lock particular tables in Database

[anuragshrivastava64]

Hi All,
Is it possible anyway to lock only a few tables in ms-access database.

[debasisdas]

try this sample code if using DAO

[CODE=vb]
Dim D As Database
Dim S As Recordset

Set D = OpenDatabase("E :\DAS\EMP.MDB", True)
Set S = D.OpenRecordset ("EMPLOYEE", dbOpenTable, dbDenyRead + dbDenyWrite)[/CODE]