2. ASPRunnerPro General questions
  3. Access database updates
This topic is locked

Access database updates

 		1/14/2009 11:07:21 AM
ASPRunnerPro General questions
I
 itsme22012000 author

when i pushed my application to the demo account everything works find for adding records and updating records.
when i upload to my web server i can add records but it will not allow me to update records i get the followinf message
<<< Record was NOT edited >>>
Field cannot be updated.
any sugestions ?
thanks,
woody
S
 		srikanth 1/14/2009

check with the permissions as well as field validation..........
J
 		Jane 1/15/2009

Hi,
please make sure that auto-increment fields are not on the edit page.
I
 		itsme22012000 author 1/16/2009

Hi,

please make sure that auto-increment fields are not on the edit page.


Jane,
Thanks for that information I removed the auto-increment fields and it works fine
Woody
O
 		onewaygo 1/16/2009

Hi,

please make sure that auto-increment fields are not on the edit page.


Hi jane,
For an instance as below:
2 tables: T1 is customers ID table, T2 is all orders from customers. tables joins with customersID(T2) and ID(T1)
you know ID(T1) should be designed as a auto-increment field, then my question is HOW TO ADD and EDIT the customer record with the customers's name if auto-increment fields are not on the edit page.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=36886&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
J
 		Jane 1/20/2009

Hi,
In general ASPRunner do not support to update joined fields on the add/edit pages.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.