<field> field not updateable.

[gslick]

Hi,

I am using a MS Access backend on Windows 2000 using FAT (not NTFS) System.

I have designed a web page which inserts data into a table (which works), but if i try and update the table, I get a '<field> field not updateable.

Why ?

The field is not a primary key or an AutoNumber, its just a text column.

Any Ideas ?

Thanks

p.s. I have a primary key on the table which is also an autonumber

gslick

http://www.uosb.co.uk

 

[lespaul]

what's the SQL for the update?

Leslie

 

[gslick]

UPDATE <table>
SET <field> = @Field
WHERE
<Parm> = @Parm

 

[lespaul]

do you have a field named

<field> in the table?

That's what your error message suggests to me; that the value of <field> isn't being passed correctly.

Leslie