Posted by Jan Willem on 11/29/05 21:00

you should set your permissions to MODIFY or FULL. Write is not enough.


"Chad Lupkes" <chadlupkes@gmail.com> wrote in message
news:1133149227.937574.222980@g44g2000cwa.googlegroups.com...
> Ok, I've been researching this for about an hour.
>
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation
> must use an updateable query., SQL state S1000 in SQLExecDirect
>
> I've checked that Microsoft page for Article ID : 175168, and checked
> all of my settings. The file is not set to read-only. It has to be my
> code. I'm not that familiar with SQL, so I'm probably doing this
> wrong:
>
> $Update = "UPDATE internaltest SET LastContact = now()
> WHERE Email = '$mail_to'";
> $result = odbc_do($connectionstring, $Update);
> if(!odbc_num_rows($result)) echo "Date Update Successful";
> else echo "Date Update Failed";
>
> This comes after sending an email to an opt-in mailing list that I
> currently have in MS Access. The script sends the emails just fine,
> but I ran up against the time limit during my first attempt. Now I
> want to select only those records where the LastContact field is
> earlier than 11/27/05.
>
> Any help would be wonderful.
>

[Back to original message]