Writing to Data Access Pages

M

Mo

Hi There,

I'm hoping someone can help me. I have a few data access pages setup
reporting data from Access databases I have setup. I've found it straight
forward so far to display the data in these data access pages.

My question is, is it possible to actually write to the database using
these data access pages? At present I can go into my data access page and
modify a field but I have no way of having this data mirrored within the
database?

Thanks in advance,

Mo..
 
K

Ken Snell [MVP]

Yes, you can write data to a database using a data access page. Note that
DAPs have more restrictions on the types of queries that are updatable
compared to forms.

One common "error" is if you don't specify the Unique Table property for the
section of the DAP that has the recordset that you're using to display the
data. You must put a table name in that property for the DAP's data to be
updatable -- although having a table name there does not guarantee that the
data are editable.
 
Top