SQL Error *** RESOLVED ***

[aaronskw]

I've got a PHP application which reads and updates an MS Access database using odbc and all is working fine. Then when I do a compact and repaire on the database and re-run my php application I get the following sql error:

'Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
Operation must use an updateable query., SQL state S1000 in
SQLExecDirect in c:\inetpub\wwwroot\specac\ppc\home.php on
line 20"

But when I revert back to the dbase before the repair everything's fine again. Has anyone ever come across this before.

Hope someone can help

[phpman]

what are line 18-23?

also it sounds like you repair messed up your table.

[aaronskw]

$Key = time();
//echo "Key $Key";
$result2 = odbc_do ($con, "UPDATE Users SET Key='$Key' WHERE UserID=".$row[1].""); 

This works fine apart from after a compact and repair. Also, this only happens on my XP pro machine but on our Win 2000 Server machine I don't get any errors after a compact and repair. Could it be the odbc access drivers on XP. What do you think?

I'm getting really weird php problems ain't I? I'm starting to think php doesn't like me.

[aaronskw]

After months and months I finally tracked this problem down to the Windows Security settings on the database. Arrrggghh.

[ober0330]

Do yourself a favor and use something that doesn't need to be "compacted and repaired" all the time.