Security settings win2000/PHP/Access(ODBC)

Anon

How to change the security settings so :
Insert Into will work. Syntax is correct, works thru local ODBC.

SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in

Anon

Problem solved, had to edit the file attributes on the .mdb file so internet users can edit it.

Runnion

Ugh! I'm having the exact same problem. Could you specify exactly what you did?

I've got a fine SQL statement and I get...

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in

both on a local server and my ISP.

That's from this update query...

$query = "UPDATE links SET link='" . $link . "', link_description='" . $link_description . "' WHERE link_ID=" . $link_ID . ";";

zudo

HELP IT"S EXACTLY THE SAME WITH ME!!!

please tell me how you changed the file attributes. please

BulldogGC

Come on ... can anyone please tell us how to do this?
I have the exact same problem.

zudo

do not use odbc or microsoft access. i needed it for visuals fournatley there is a thing called phpmyadmin which is basicly the same but for my sql goto www.soufceforge.com to download it... it saved me alot of trouble... and i still don't know how to change attributes for access!

BulldogGC

This is a product designed for a client. I do what they ask, they want PHP and MS Access for whatever odd reason ... not my problem. The final product will be on an entire dc worth of IIS boxes ... I suggests MSSQL and VB.net but no dice. So now I'm still left with the need for an answer to how to make PHP work with MS Access please. Any help would be appreciated, thanks.