Locking only the edited record

  • Thread starter Thread starter diarmuidq
  • Start date Start date
D

diarmuidq

Using Access 2000, editing a record locks the page. As far as I know, that
is the limit in Access 2000.
Is it possible in XP or 2003 to only lock the record itself? Or is there no
way of doing this.
Thanks
Diarmuid
 
diarmuidq said:
Using Access 2000, editing a record locks the page. As far as I know, that
is the limit in Access 2000.
Is it possible in XP or 2003 to only lock the record itself? Or is there no
way of doing this.
Click to expand...

Record level locking began with Access 2000.

Look in Tools ... Options
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
diarmuidq said:
Using Access 2000, editing a record locks the page. As far as I know,
that is the limit in Access 2000.
Is it possible in XP or 2003 to only lock the record itself? Or is
there no way of doing this.
Thanks
Diarmuid
Click to expand...

You need to open the database with record-level locking -- there's a
check box for that on the Advanced tab of the options dialog. As I
understand it, in a multi-user database, the first user to open the
database sets the locking option.
 
That worked. I had only ticked the Edited Record option. Is there a way to
set this through code?
Thanks
Diarmuid
 
Hi Diarmuid ,

We can try the following code to set the default record locking to Edited
Record.

Application.SetOption "Default Record Locking", "2"



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.




--------------------
| From: "diarmuidq" <[email protected]>
| References: <[email protected]>
<#[email protected]>
|
| That worked. I had only ticked the Edited Record option. Is there a way to
| set this through code?
| Thanks
| Diarmuid
|
| | > | > > Using Access 2000, editing a record locks the page. As far as I know,
| > > that is the limit in Access 2000.
| > > Is it possible in XP or 2003 to only lock the record itself? Or is
| > > there no way of doing this.
| > > Thanks
| > > Diarmuid
| >
| > You need to open the database with record-level locking -- there's a
| > check box for that on the Advanced tab of the options dialog. As I
| > understand it, in a multi-user database, the first user to open the
| > database sets the locking option.
| >
| > --
| > Dirk Goldgar, MS Access MVP
| > www.datagnostics.com
| >
| > (please reply to the newsgroup)
| >
| >
|
|
|
 
Thanks. From now on I'll open my databases with
Application.SetOption "Default Record Locking", "2"
Application.SetOption "Track Name AutoCorrect Info", False
Application.SetOption "Use Row Level Locking", True

Interesting that the Access 2000 help has the incorrect "Use Record Level
Locking" instead of "Use Row Level Locking"
Regards
Diarmuid
 
Yes, its next time. Which isn't too bad though, at least I talk people
through opening and closing the app over the phone.
 
Back
Top