Can't edit data on a Data Access Page

[Guest]

I created a web page using the Data Access Page feature in Access. However,
the web page only displays the table data. The page will not allow me to edit
the data displayed. The page's property for "ConnectionString" has
"mode=Share Deny None". The Group Level property for "AllowAdditions",
"AllowDeletions", & "AllowEdits" are set to "True". Also the Element property
for "ReadOnly" is set to "False". Why won't it allow changes to the table
data displayed?

 

[Ken Snell [MVP]]

Did you define the Unique Recordset property for the page's section that has
the data? Are you using a query for the recordset that may be nonupdatable
(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)?

 

[Guest]

The page is directly bound to a table (a query is not used). The section
property for "UniqueTable" is set to the name of the table. So it should be
updatable. Any futher ideas?

 

[Ken Snell [MVP]]

Do you have an element bound to the table's primary key field? Even if it's
hidden, it needs to be on the Data Access Page if you wish to edit data.

 

[Guest]

That was it !! Would have taken me a million years to solve that one! thnx ;.)

 

[Ken Snell [MVP]]

You're welcome. The primary key must be specifically included in the Page's
recordset this way so that the database engine knows which record you're
updating.