Software

Ask something
Discussion Locked

Access 2K Data Access Pages can't edit

0 helpful
5 replies

by hotzmiller

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to use Data Access Pages to allow users to update data through our intranet web site. I created a query to bring up a subset of the data (basically filtering by sales rep). I can edit and save the data if I open the query. However, after creating a Data Access Page from the query, I can't save any data edited via the Data Access Page. I have altered the properties of the fields I want the users to edit (ContentEditable = true). I can edit the value in the field, but can't saveit. On the navigation toolbar, the data entry buttons are grayed out.

Thanks in advance for your assistance!

5 replies

by hotzmiller

Perhaps I am revealing my ineptitude here, but I am trying to make this work as I go. I tried editing the page's DataEntry attribute from Flase to true, but it did not help, instead the page came up with no records at all.

I really do not understand why I can't update. A form created from the same query has no trouble updating the database. I can use forms instead od Data Access Pages if I must, but MUST I? I want to use the web pages.

by mslizny

I am not sure of the exact nature of your problem, but here are two ideas:

Usually when a web page cannot update the data source it is because there is some missing link between the web page and the data.

Sometimes a query itself is not updatable. You will want to check this property.

by hotzmiller

Thanks for your response. The issues you suggested do not appear to be the problem. I gave uyp and just used regular old forms, which worked fine.

This discussion is closed to new replies.