Operation must use an updateable query
can anybody tell me wat this error means??
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:\inetpub\wwwroot\amega\shared.inc on line 8
July 10th, 2002, 01:04 AM
Will code for food.
July 10th, 2002, 01:10 AM
line 8 :
July 10th, 2002, 12:55 PM
It almost sounds like you're trying to update a view which is not updateable?
What is your SQL and table structure for the query?
July 10th, 2002, 11:39 PM
well, when i use windows98, access 2000, php4.0.6 to do the testing, everything works fine.
but when i use windows xpprofessional, access xp, php4.1.2, then i got this error and record cannot save to the table.
i tried to recreate the database in accessxp, but i still got this error.