Hello all,
The form in question opens from a click event on another form - showing the details of an order, with a subform that shows the line items.
Everything has been working fine until today (about a year or so).
I have 4 records that I cannot edit.
When the form opens, it checks who the user is, and grants permissions based on their level of authority. If a record edit is needed, a button is provided that will change the AllowEdits property to True.
However, these 4 records cannot be edited even though it is true.
I have imported the two tables into my development database, and I CAN edit them there. So, I compiled the database, compacted and repaired, distributed the dev copy to the network...and I still have the same problem.
I have the form record lock set to edited record, as well.
Only thing that I have noticed is that someone may have been using the network copy of the front end, instead of the one that should be on their local machine, because I found a .laccdb file, which I deleted before redeploying the dev version to production.
Thoughts?
The form in question opens from a click event on another form - showing the details of an order, with a subform that shows the line items.
Everything has been working fine until today (about a year or so).
I have 4 records that I cannot edit.
When the form opens, it checks who the user is, and grants permissions based on their level of authority. If a record edit is needed, a button is provided that will change the AllowEdits property to True.
However, these 4 records cannot be edited even though it is true.
I have imported the two tables into my development database, and I CAN edit them there. So, I compiled the database, compacted and repaired, distributed the dev copy to the network...and I still have the same problem.
I have the form record lock set to edited record, as well.
Only thing that I have noticed is that someone may have been using the network copy of the front end, instead of the one that should be on their local machine, because I found a .laccdb file, which I deleted before redeploying the dev version to production.
Thoughts?