Notify that recordset is already being edited

D

Daniel P

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
 
P

Pieter Wijnen

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?
 
D

Daniel P

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
 
Top