I know this is a really simple question - but I have created an update page on my site and for the life of me I can't seem to get it to work (www.acid-rage.org/asptest/modify.asp)

I seem to get Error 500 errors - help <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

The Error i get is 'Unable to update ID field', cos its not updateable (or something like that)

Is this an autonumber field in your database???

If it is, ignore it from your update behaviour.
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Leed

Only update fields that you need to update.

When creating the recordset choose the 'Selected' radio button not the 'All' button.

Then choose which fields you want to update.

Also in the advanced dialog you'll see something like:

SELECT fnONE,fnTWO

(fnONE,fnTWO being two mock field names)

What you DON'T want to see is:

SELECT *

Otherwise you'll get the error.

www.k.abbott.btinternet.co.uk/