I am accessing a database for readonly purposes, and do not want to interfere with anyone that might be trying to access and/or modify the same data. I have set Connection.Mode = adModeShareDenyNone and have used the default RecordSet.LockType = adLockReadOnly. I am not sure whether the adLockReadOnly prevents other people form modifying the data or if it only prevents me from modifying the data.

Thanks in advance.

dslagle,

The LockType is only based on that particular Recordset.

The defacto standard for Recordsets like this is to use a Read-Only-Forward-Only (ROFO) cursor. So set the LockType to adLockReadOnly and the CursorType to adOpenForwardOnly.

Regards,

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>