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:
  1. 'Connect to recordset
  2.     Set Db = dbEngine.Workspaces(0)(0)
  3.     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