| | |
|
|
|
Notify that recordset is already being edited |
|---|
| message from =?Utf-8?B?RGFuaWVsIFA=?= on 6 May 2004 |
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
|
| Pieter Wijnen replied to =?Utf-8?B?RGFuaWVsIFA=?= on 6 May 2004 |
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" <anonymous@discussions.microsoft.com> wrote in message
news:522BA57C-CC54-47FC-940B-B730ECF12F4E@microsoft.com...
there a way to display a message when someone loads a recordset that another
person also has open?
|
| =?Utf-8?B?RGFuaWVsIFA=?= replied to Pieter Wijnen on 7 May 2004 |
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
|
|
Archived message: Notify that recordset is already being edited (Microsoft Access)
