by I have a VB5 (SP3) application that reads and writes to multiply table
within a access database and I have been unable to lock the recordset
that I am using when inserting a new record, which is causing
collisions. I have however set the database to be open exclusively when
a user is inserting,reading,updating, etc. This in turn causes
performance issues. Is there a way to lock a recordset. An example
would be great.
thanks,