Using Data Access Pages to edit data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Lynx - 29 Jun 2007 00:28 GMT

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?

Reply to this Message

Ken Snell (MVP) - 29 Jun 2007 01:54 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

>I am trying to use Data Access Pages to edit data in a MIS database.
>
[quoted text clipped - 7 lines]
>
> What am I missing?

Reply to this Message