Data Access Page Un-editable

[Cameron]

I created a DAP from a form I have built, but none of the text fields, or
check boxes allow me to edit them while in the DAP. I am trying to read up
on DAP's but I have not found anything that helps me understand how to set
them to be editable. Can someone help?

 

[Cameron]

more info for you: I am using office 2003 SP3 and IE7. I have installed
OWC11. I have the access database and the DAP (HTML Document) saved in the
same folder as the db.

 

[Ken Snell]

Data Access Pages are more often noneditable because the query does not
allow the identification of the unique table being edited.

Did you set the Unique Table property of the Section's Data tab to be the
table that is being edited?

Also, do you have a control on the page that is bound to the primary key
field of the table? The control can be invisible/hidden, but it needs to be
on the page for the page to correctly identify the record.

Also, note that DAPs will not allow editing with many queries that are
editable in a form. This can be somewhat frustrating....

 

[Cameron]

I added a primary key and made sure it was added to the query and now the DAP
is editable. Thanks. I have a button on the form to close the form.
Obviously now it would be used to close the browser I guess. Any quick fix
to fix the button to do so? I am able to open script editor for the page.

 

[Ken Snell]

You don't want to close a DAP unless you have another one open, else you
lose the ability to interact with the database unless you start over with
the beginning URL. So normally one uses a button to navigate from the
current DAP to a different DAP. You don't actually close the DAP itself.