Results 1 to 5 of 5

Thread: SQL Error *** RESOLVED ***

Threaded View

  1. May 14th, 2003, 12:11 PM #1
    aaronskw
    aaronskw is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    South Wales (UK)
    Posts
    83

    SQL Error *** RESOLVED ***

    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
    Last edited by aaronskw; Jul 22nd, 2004 at 09:04 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width