Notify that recordset is already being edited

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I had a database that is used by numerous people on a network server. Is there a way to display a message when someone loads a recordset that another person also has open?

Thank you in advance

Daniel
 
yes,
you can (attempt) open it with the dbDenyWrite option.
that should give you an trappable error

Dim Rs as DAO.Recordset
Set Rs = Access.CurrentDB.OpenRecordset("SELECT .. FROM ..
",DbOpenDynaset,DbSeeChanges + dbDenyWrite)
....


HTH

Pieter


Daniel P said:
Hello,

I had a database that is used by numerous people on a network server. Is
Click to expand...
there a way to display a message when someone loads a recordset that another
person also has open?
 
Pieter

Could you explain a little more. Where do I need to use this function.... I don't want to lock the database by the first user to logon to the database. I only want to lock individual recordset while a user is viewing/editing it

Thank you for your help

Daniel
 
Back
Top