General discussion

Locked

Access 2K Data Access Pages can't edit

By hotzmiller ·
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!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2K Data Access Pages can't edit

by hotzmiller In reply to Access 2K Data Access Pag ...

Also, the Read Only attribute is set to False.

Collapse -

Access 2K Data Access Pages can't edit

by hotzmiller In reply to Access 2K Data Access Pag ...

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.

Collapse -

Access 2K Data Access Pages can't edit

by mslizny In reply to Access 2K Data Access Pag ...

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.

Collapse -

Access 2K Data Access Pages can't edit

by hotzmiller In reply to Access 2K Data Access Pag ...

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.

Collapse -

Access 2K Data Access Pages can't edit

by hotzmiller In reply to Access 2K Data Access Pag ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums