Table locked when displayed in subform

%3CLINGO-SUB%20id%3D%22lingo-sub-2079204%22%20slang%3D%22en-US%22%3ETable%20locked%20when%20displayed%20in%20subform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2079204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EI%20have%20a%20table%20that%20gets%20populated%20with%20a%20couple%20queries.%20When%20that%20table%20is%20opened%2C%20it%20becomes%20locked%20and%20the%20queries%20will%20not%20function%3C%2FSTRONG%3E.%20To%20avoid%20having%20people%20open%20the%20table%20directly%20to%20view%20the%20data%2C%20I'd%20display%20the%20table%20in%20a%20datasheet%20view%20in%20a%20form%20with%20the%20recordset%20snapshot%20(which%20i've%20done%20already)%20but%20even%20displaying%20it%20here%20locks%20it.%20I%20can't%20see%20any%20combination%20of%20settings%20that%20prevents%20this%20table%20from%20getting%20locked.%20If%20the%20datasheet%20property%20is%20Locked%3AYes%2C%20it%20can't%20be%20manually%20edited%20but%20the%20table%20itself%20gets%20locked%20and%20the%20query%20won't%20update%20it.%20If%20i%20change%20the%20properties%20to%20Locked%3ANo%2C%20it%20still%20locks%20the%20table%20anyway%20and%20the%20queries%20still%20fail%20(but%20the%20data%20is%20editable%20within%20the%20subform%3F!).%20Any%20idea%20how%20I%20can%20display%20this%20table%20without%20locking%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20form%20does%20contain%20another%20datasheet%20that%20i%20need%20to%20remain%20editable%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBigger%20picture%3A%26nbsp%3B%20Ultimately%20I'm%20trying%20to%20get%20this%20table%20displayed%20in%20a%20subform%20in%20a%20form%20while%20remaining%20%3CEM%3Enot%20locked%3C%2FEM%3E%20so%20that%20the%20queries%20run%20via%20VBA%20can%20make%20changes%20without%20error.%26nbsp%3B%20The%20form%20contains%20access%20to%20a%20datasheet%20to%20enter%20data%2C%20a%20couple%20buttons%20for%20VBA%2C%20and%20this%20table%20as%20a%20display%20for%20results.%26nbsp%3B%20The%20form%20has%20Record%20Locks%3A%20No%20Locks.%26nbsp%3B%20The%20subform%20has%20Locked%3A%20No%20(changing%20this%20does%20nothing).%26nbsp%3B%20None%20of%20this%20really%20matters%3A%20ultimately%20the%20issue%20is%20%3CSTRONG%3Ew%3C%2FSTRONG%3E%3CSTRONG%3Ehen%20that%20table%20is%20opened%2C%20it%20becomes%20locked%20and%20the%20queries%20will%20not%20function.%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3EWhen%20the%20table%20is%20displayed%20in%20the%20subform%2C%20it%20becomes%20locked%20the%20same%20way.%26nbsp%3B%20How%20can%20I%20ensure%20that%20a%20table%20is%20viewed%20in%20a%20way%20that%20does%20not%20lock%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2079204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELocks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a table that gets populated with a couple queries. When that table is opened, it becomes locked and the queries will not function. To avoid having people open the table directly to view the data, I'd display the table in a datasheet view in a form with the recordset snapshot (which i've done already) but even displaying it here locks it. I can't see any combination of settings that prevents this table from getting locked. If the datasheet property is Locked:Yes, it can't be manually edited but the table itself gets locked and the query won't update it. If i change the properties to Locked:No, it still locks the table anyway and the queries still fail (but the data is editable within the subform?!). Any idea how I can display this table without locking it?

 

The form does contain another datasheet that i need to remain editable

 

Bigger picture:  Ultimately I'm trying to get this table displayed in a subform in a form while remaining not locked so that the queries run via VBA can make changes without error.  The form contains access to a datasheet to enter data, a couple buttons for VBA, and this table as a display for results.  The form has Record Locks: No Locks.  The subform has Locked: No (changing this does nothing).  None of this really matters: ultimately the issue is when that table is opened, it becomes locked and the queries will not function.  When the table is displayed in the subform, it becomes locked the same way.  How can I ensure that a table is viewed in a way that does not lock it?

0 Replies