Using Data Access Pages to edit data

[Phil Lynx]

I am trying to use Data Access Pages to edit data in a MIS database.

I can display the data with no problems but I cannot edit it. The table is
definitely updateable. I can build a form to update it and save it as a DAP
and the data is still read only. The AllowEdits in the Group Level property
is True. The Element properties ReadOnly is False. The Page properties
DateEntry is False.

What am I missing?

 

[Ken Snell \(MVP\)]

First, be sure that you've provided in the DAP Section's Unique Table
property the name of the table that is being edited. Second, be sure that
the primary key field is bound to a control (called "element" for DAP) in
that section; it can be invisible. Third, depending upon the query, it's
possible that the DAP will not accept the query as being editable,
especially if it has some joins in the query -- DAPs are much more limited
in which queries can be edited -- one that works for a form may not work for
a DAP.