I am trying to lock a table so that no one can edit it while its open.
This is in VBA using MS Access 2002.
I am opening my table as follows, as long as this table is open I want it locked.
VB Code:
'Connect to recordset Set Db = dbEngine.Workspaces(0)(0) Set RstImport = Db.OpenRecordset("SELECT * FROM " & dbTable)
And how do I check if the table is locked because if its locked I want to prompt the user "Hey this table is locked!"
Thanks




Reply With Quote