I am accessing a dBase 4 table through VB6:

Set WkSpace = DBEngine.Workspaces(0)
Set dbPhoto = WkSpace.OpenDatabase(strDBPath, False, False, "dbase iv;")

Q: How do I lock the whole table, and how do a lock an individual record...

I currently use the following code to generate the recordsets:

strSQLSearch = "Select * from " & gstrTableName & " where FILENAME = '" & _
                                gtypPhoto(gintIndex).strOldPhoto & "'"
Set rsSearch = dbPhoto.OpenRecordset(strSQLSearch)

I've tried using the OpenRecordset Options and LockEdits arguments but I get
a 3001 error: "Invalid Argument..."

Can anyone point me in the right direction?

Thanks in advance