Single-user database

[pepepito78]

Good Morning, i have a shared bbdd access on network. Do you know how to prevent it from being opened by another user once opened? Thank you

 

[arnelgp]

you need vba for that.
if your db is not split, you need to add this on a Module

Public Function open_denywrite()
    Static rs As DAO.Recordset
    Dim db As DAO.Database
   
    Set db = CurrentDb
    On Error GoTo access_fail
    Set rs = db.OpenRecordset("table1", dbOpenDynaset, dbDenyWrite)
    Exit Function
access_fail:
    MsgBox "Somebody has opened this already!"
    DoCmd.Quit
End Function

create an Autoexec macro that will Run (Runcode) the above function.
"table1" there is but sample table, you may use a "dummy" table or temp table.

 

[Ranman256]

No, but if you make it split (sharable), tHen it won't matter.

 

[pepepito78]

Thank you

 

[Deleted member 147267]

Do you know how to prevent it from being opened by another user once opened?

Open it in exclusive mode?