Operation must use an updateable query

What is the query and what data is in that row?
What are you trying to do?

just trying to insert data into database.

line 8

What query was run just prior to that?

That is line 8 of shared.inc?

I'm not familiar with ODBC... what happens when you take that line out?
is it necessary to have it in there?

well, when i test this system using windows98, php4.0.6 and access 2000, everything works fine.

but when i used windows xp professional, php4.1.2 and access xp, i got this error and data are not inserted into the table.

i tried to recreate the database in accessxp but still getting the same error.

i dun think is my query's problem cos everything works fine when i tested in windows 98.

Sounds to me like the security settings in XP are tighter. Check to make sure the directory your database is in has read/write access for the IUSR & IWAM accounts. If that fails try throwing the database inside a folder in your website (unless it is already!)

Quote:
Check to make sure the directory your database is in has read/write access for the IUSR & IWAM accounts.

how to check tat? how to change it to write access??

ok, even it's in read access, if i recreate the whole database in xp, i still got the error..

and its already in a folder..

Just use Windows Explorer to navigate to the folder that the database is in, do a right-click on the folder and select properties, then click the Security tab and see what accounts have permission on that folder.