Hi Chad

Make sure the webserver has write permissions on the Access database file.


t: 01903 739 997
w: www.thelittledot.com

The Little Dot is a partnership of
Ronan Chilvers and Giles Webberley

On 28 May,2003 at 23:02 Chad Chad wrote:

> I am using PHP 4.2.3  on a Window 2K Pro box with Service Pack 3 installed.
> I am trying to access an MS Access 2000 database through the MS Access ODBC
> driver.  When I try to write to a table, using an INSERT INTO command (see
> below) I get the following error:
> "Operation must use an updateable query"
> The SQL statement that I am trying to odbc_exec is as follows:
> INSERT INTO testtab ([user_name],[subject],[comment]) VALUES ('chad','test
> data','Comment x')
> This works when I run it as a query in MS Access, and I've been able to get
> info from the database using "SELECT" statements.
> I'm just not sure what the "Operation must us and updatable query" means.
> I actually found the same error in the help files for MS Access and this is
> what it says, but to me it is just as unintelligible as the message:
> This error occurs when the current query's Update To row includes a field
> from either a crosstab query or select query in which an aggregate (total)
> was calculated for the field (using either the Totals row or a domain
> function in the Field row). To update a field using the aggregate of another
> field, calculate the aggregate in the update query itself, not a different
> query.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to