PDA

View Full Version : Data Access Page Read-Only!



ProteanBeing
04-09-2008, 03:21 PM
I have created a data access page from a query with one input parameter. When I enter the parameter the data is read only. How do I make the data updateable?

Trevor
04-09-2008, 03:57 PM
on form proporties for the form, allowEdits = Yes, allow additions = yes

ProteanBeing
04-10-2008, 04:48 AM
This is a data access page, not a form. The Group level allows are all true

ben.oates
04-10-2008, 04:56 AM
According to replies here (http://www.access-programmers.co.uk/forums/showthread.php?t=100684), a DAP will only update when the source data has a unique primary key - and apparently adding grouping levels makes the page read-only. Does your data have a unique primary key?

Also, if the DAP is run from a query view rather than a straight table view the system may not be able to update the data (the same problem applies in Access itself).

Trevor
04-10-2008, 01:31 PM
Thanks protean, I didn't know access pages were like that