Subform "frozen" after enabling user-level security?

[VBAjedi]

I built out an Access 2003 database with a variety of forms/subforms, and then today I turned on user-level security.

Now one of the subforms is "frozen" - it won't let me add new records or edit existing ones. I CAN go into the underlying table and edit values there directly.

As far as I can see permissions are set the same for this problem subform as for all the other forms. I'm logged in as a user that's part of the admin group with full privileges to everything on that form (and all the other forms/tables). But no go - I can't change/add anything on that subform.

How do I troubleshoot this further?

VBAjedi

 

[lameid]

My guess is that your record source for the form is a query and the permissions on the query are not correct.

 

[VBAjedi]

That sounded promising, but unfortunately when I checked the query's permissions they were as they should be (giving my login full access)

The fact that only one form is acting up makes me suspect that this might not be a User-level security problem after all. Maybe it's an error caused by an earlier, unrelated, action that I just didn't catch until after I enabled security. Checking out that angle now...



VBAjedi

 

[VBAjedi]

Got it. My hunch was right... a tweak I recently made to the underlying query (joining another query to it to pull in one field) somehow broke the add/update ability of that query. Still not sure why, but undoing it cleared up the issue. Now to sort THAT problem out...

Thanks!

VBAjedi