Open databases by using record-level locking via VBA

[ry94080]

Hello,



Would anyone happen to know how to configure the highlighted item below with VBA?



Thanks!

[orange]

Did you try clicking the checkbox?

[ry94080]

Did you try clicking the checkbox?

Of course, but as i stated in the question, is if this is possible to edit that setting via VBA...

[Welshgasman]

So have a look at the properties of the db, and see if that property is mentioned?
However, it might turn out to be read only.

[orange]

This link suggests you can set lock parameter on Recordset. Lots of results re Recordset locking with vba. I did not find an parameter/property for Database, but only tried Google.

[Welshgasman]

Here is a snippet of code to check your db properties. Access 2007 does not even have that option in the list.

Sub dbProperties()
Dim prp As DAO.Property
Dim db As DAO.Database
On Error Resume Next


Set db = CurrentDb()
For Each prp In db.Properties
    Debug.Print prp.Name & " - " & prp.Value
Next
Set db = Nothing
End Sub

[CJ_London]

Access 2007 does not even have that option in the list.

a lot of properties are not created until actually used - tick the box and run the code again to see if it is returned. Untick it and it should still be there

[Welshgasman]

a lot of properties are not created until actually used - tick the box and run the code again to see if it is returned. Untick it and it should still be there

No, I mean, I do not have the Client Settings option in my list of options.

[CJ_London]

No, I mean, I do not have the Client Settings option in my list of options.

Surprising

[Welshgasman]

Surprising

Well it is 2007