Suddenly I cant make a DAP that accepts input. ERROR: READ ONLY!

[Frustrated DAP user.]

I've setup a few DAP pages that allow changing the data in my DB, and
suddenly when I create one it only allows me to see data, not change it. VERY
FRUSTRATING! Nobody seems to have the answer. It seems to have begun when I
moved my default data connection file to the server that holds the DB. Since
then I have not been able to create a DAP that allows input. I've even tried
to create a page that directly points to my tables, thinking it was something
wrong with my query. I've changed the "Default " back to my local one, no
luck. My "Default" connection file simply points to the access database. The
pages I created before this problem still work fine, but when I try to create
another (identical) page with the same settings (query) it gives the error
that you can not save the input to the underlying table. Anyone have this
problem? How do you fix it? Microsoft doesn't seem to have any information
about it on thier websites.
HELP!

 

[Ken Snell \(MVP\)]

Common reasons why a DAP doesn't allow editing of the data:

You must define the Unique Recordset property for the page's section that
has the data.

You must have an element bound to the table's primary key field. It can be
hidden, but it needs to be on the Data Access Page if you wish to edit data.

You must use an updatable query for the recordset (note: Data Access Pages
are more picky in what's updatable and what's
not -- a query that works in a form may not work in a page).

 

[Frustrated DAP user]

Common reasons why a DAP doesn't allow editing of the data:

You must define the Unique Recordset property for the page's section that
has the data.

You must have an element bound to the table's primary key field. It can be
hidden, but it needs to be on the Data Access Page if you wish to edit data.

You must use an updatable query for the recordset (note: Data Access Pages
are more picky in what's updatable and what's
not -- a query that works in a form may not work in a page).

 

[Frustrated DAP user]

Thanks Ken that worked out great!
Perhaps they should go into that subject in the help files.