Are you checking the properties of the actual forms to see if they are set to lock the table when it opens. This would be on the data tab of the form I believe.
I checked each form and they are set not to lock under the data tab of the form properties. I'll let you know when I have created a...
I went to TOOLS > OPTIONS > ADVANCED TAB
under the default record locking options
I tried selecting each option (No lock, All records, edited record) with Open databases using record-level locking checked and when running the database with users in it I still get the same error.
I've seen...
I now receive this error msg after commenting On Error GoTo HandleButtonClick_Err
No debug button just an OK button. Looks like we are getting somewhere =)
The expression On Click you entered as the event property setting produced the following error.
Could not lock table 'Contacts'...
Private Function HandleButtonClick(intBtn As Integer)
' This function is called when a button is clicked.
' intBtn indicates which button was clicked.
' Constants for the commands that can be executed.
Const conCmdGotoSwitchboard = 1
Const conCmdOpenFormAdd = 2
Const...
The dialog box only pops up when you try to navigate through the switchboard to other forms while another user is using a form to enter data. The dialog does not have a debug button. The dialog shows the error msg that has an OK button. After the message is acknowledged it returns to the...
Not using recordsource property.
I removed the form from loading at start up by going to Tools > Startup > Display Form/Page and tested the DB. Still the same error. I am merely using the code to display the switchboard form. It is generated code. I did not modify it.
That's all I have.
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True
End Sub
Is this where I should post this question?
I have a database that is being used by multiple users. Each user has an MDE file on their PC and the data is stored/referenced in a separate mdb on a network shared drive. When someone is using the program concurrently and a second user tries to open...
I have a database that is being used by multiple users. Each user has an MDE file on their PC and the data is stored/referenced in a separate mdb on a network shared drive. When someone is using the program concurrently and a second user tries to open forms, etc. I always receive the following...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.