Update a query based view Access 2013 Web App (1 Viewer)

William Demuth

Registered User.
Local time
Today, 02:01
Joined
Feb 16, 2011
Messages
35
I have just begun playing with Web Apps.

All is well with one issue bugging me to no end

I have a view (Based on a query involving two tables) that will not permit updates

All looks good, but my Edit option is grayed out.

Documentation is horrible. Can anyone suggest where I might begin to resolve this?
 

Rx_

Nothing In Moderation
Local time
Today, 00:01
Joined
Oct 22, 2009
Messages
2,803
"Documentation is horrible.." thanks for the confirmation.
Will take a stab on this based on watching a couple of demos.
The recordset (so I am told) is limited so it doesn't swamp the network.
Kind of like running a Top 50 Query. That would seem concerning to me regarding updates.
My suggestion is to make sure the query only returns a single unique record for both tables. Then, use an update SQL statement rather than a recordset object.

Please be sure to let us know what you find. Your discovery would be valuable in the absence of real documentation.
 

Users who are viewing this thread

Top Bottom