Hi all.

I’ve written an invoice system for a local garage using IIS on Windows 7 and it works like a dream – using an Access DB logged under the System DSN in the default ODBC window. Unfortunately when I copy the code to their old XP Pro SP1 box I get the following error every time the code tries to run an UPDATE or INSERT statement…

“Operation must use an updateable query” etc etc

I’ve been into every permissions box in the OS and in IIS I can think of, threw all kinds of write permissions but still no dice.

It reads ok and I’ve actually managed to get the date functions working in UK order. But can’t write to the database…

I would really appreciate a steer…I’m very stuck!

Many thanks.

D

For a start, Don't double post. Secondly, it is the query that is the source of the prolem not the OS.

What does the SQL of the query look like?

For a start, Don't double post. Secondly, it is the query that is the source of the prolem not the OS.

What does the SQL of the query look like?

Thanks for the reply. I'm not convinced that it is the query at fault, as this query works on other Win XP machines (a reusable one that I've used a lot of times over the years), NT4, Win 2000 and as I've said Win 7. I still think this may be an environmental issue with permissions, as I say it's strange that the error only crops up with Insert and Update statements - all Selects are fine.

Here's the SQL as requested, any help much appreciated....

sqltextJsUpdate = "UPDATE jobSheet SET deleted='yes' where invoiceNumber='"&invoiceNumber&"'"

(or version with variables removed)

UPDATE jobSheet SET deleted='yes' where invoiceNumber='12345'

PS - both deleted and invoiceNumber are text fields (not boolean or int)

This may sound unusual but what is the path on the Win 7 machine where the app is installed?

This may sound unusual but what is the path on the Win 7 machine where the app is installed?

Hi there. It's C:\websites\companyname\eea.mdb. I keep the ASP files in the same directory. The ASP files connect to the database through ODBC (DSN assignation in the code).

On the Win XP box it's the same folder. All very strange....