Hi Chad
Make sure the webserver has write permissions on the Access database file.
Cheers
Ronan
e: ronan@thelittledot.com
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
