Help
I have a Access FE/Access BE (split DB) situation where the end users all have their own FE ACCDE file. Amount of users is 20-100 at any given time. There are essentially 12 datasheet view forms where the user uses a drop down choice to choose one of three options and move on to the next record. This is where the error is occurring. Its been working great for months and out of no where, whammy!
So I have searched for the solution and made sure the following is done:
- All forms - No Locks
- ACCDE End User File AND Back End DB - No Locks / Open DBs by using record level locking / Default open mode - Shared
- Compacted and repaired both FE/BE files (End user launches with a batch file that copies the main version to their desktop and opens it from there (own copy), so all user settings are in theory the same/correct
Im at a loss. It seems that page level locking is somehow introduced in to this, because once someone has the issue multiple do and its all on the same datasheet form.
- The choice box is a combo box on the table (just read this could be an issue and maybe should be moved to the form, sigh....)
- There is a Data Macro (Before Change) on the tables that populates 2 fields, a user name field and a closed date time field.
That's it, there are no other items on the UI that the end user activates. They cannot add, delete records. All the form fields except 2 are locked down. The 2 that are not are a simple text field and the choice box.
Is the choice box a potential cause of this?