Data Access Page help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few data access pages, some will allow data input and 1 will not.
Could someone please assist?

Thanks
 
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).
 
Thanks,

That worked, you are the man!!!

Ken Snell (MVP) said:
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).
Click to expand...
 
Back
Top