locked
Does anyone know what would cause this message? RRS feed

  • Question

  • One user got this message out of the blue. We recently switched to WVD (Windows Virtual Desktop) if that matters.

    I was able to open the database myself without any issue, other than it opening slowly.

    This is the code:

    Private Sub butNew_Click()
       On Error GoTo ER
       ' Openargs N indicates 'New', in this case myRole is not passed
       DoCmd.OpenForm "frmCases", , , , , , "N"
       Exit Sub
    ER:
       MsgBox Err.Description, , "butNew_Click"
    End Sub

    Wednesday, October 14, 2020 2:58 PM

All replies

  • My current theory is that some other user had opened the back-end file and thus made it read-only.
    Friday, October 23, 2020 6:22 AM
  • this button is opening a form?   another idea would be the record set is a query.... and the query has been altered so that it is no longer an updateable query....
    Friday, October 23, 2020 11:48 PM
  • With the database closed, check the directory where the back-end file and front-end files are located. If there is a file with the .laccdb extension still showing, delete it. This lock file should only be showing if the database is open.
    Saturday, October 24, 2020 1:42 PM