ODBC connection to MS Access fails to update

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.

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.googlegr oups.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.
>