Table '' is read only

[jaybee3]

Hi there,

First off here's the structure of my database:

I have a form (addResource) that is launched from another form (MENU) in order to update the records in the Resource table.

addResource contains what's in the table Resource.



This works fine when opening the form on it's own from the navigation bar on side but when it's opened from the MENU form, and I beging to type in the Resource Name box I get "Table '' is read only".

Any suggestions?

If you need more details I'll be happy to oblige.

[RuralGuy]

What code is being used to open the addResource form from the MENU form?

[jaybee3]

DoCmd.OpenForm "addResource", acNormal, "", "", acAdd, acDialog

[RuralGuy]

What is the RecordSource of your addResource form. Query? Table?

[jaybee3]

Table (Resource)

[RuralGuy]

Ahh...make it a query of the table rather than the table directly and that should eliminate your issue. It sounds like some other object already has the table open.

[jaybee3]

Ok, tried that, now I get a blank form with no visible fields.

EDIT: Found the culprit. I had a subform on my Menu that was hidden underneath another control and it was set to All Locks.

Cheers for your help RuralGuy

[RuralGuy]

Great! If you are good to go then go ahead and use the Thread Tools and mark this thread as Solved.