Record locking problem

[jsjaedon]

Hi guys,

I have an Access database set up as a front-end and back-end. My problem is with multiple users trying to do edits to different records in this database at the same time. It's an inventory database, so items are being moved and quantities changed frequently.

my form is set up right now that you can search for data, and when you want to edit a record, you press a toggle key to activate "edit mode." I'm not sure if it's the macros or if it's some underlying access setting for multiuser record locking that i didn't set.

my advanced options are default open mode "shared," default record locking "edited record," and "open databases using record-level locking" is checked.

my macross for the toggle button to enable edit mode is as follows:

If
[Forms]![Gen Stock Search]![Edit]=True
Then I run
SetValue
Item:[Forms]![Gen Stock Search]![Gen Stock subform2].[Form].[AllowEdits]
Expression: Yes

If
[Forms]![Gen Stock Search]![Edit]=False
Then I run
SetValue
Item:[Forms]![Gen Stock Search]![Gen Stock subform2].[Form].[AllowEdits]
Expression: No


If anyone can find out what my problem is that would be greatly appreciated.

Each person has the access front-end copied to their local hd and the backend is on the network shared drive.

Thanks!