Open Access query via VBA and lock

[mikeymay]

I have used the following previously to open a query in Access and then copy the data to a holding sheet

rsQuery.Open strQuery, cnConnection, adOpenKeyset, adLockOptimistic

I now need to use the same but stop anyone else from getting any of the records that are in the recordset so effectively locking all the data in the query.

Is there a way of doing this with the .Open command?


Thanks