MS Access: "Operation must use an updateable query."

  • Thread starter Thread starter Tim S.
  • Start date Start date
T

Tim S.

Hello,
I wrote ADO.Net code that given a Query Name and
parameter array, ran the query with the parameters. The
database was MS Access 2002.
This code worked fine for 8 months under extreme
testing and production use. I upgraded to Windows XP,
installed VS.Net 2003, it now crashes saying "Operation
must use an updateable query."
The query *is* an updatable query (an Insert
statement), and works perfectly fine when run from Access.

Does anyone know what could cause such an error?

Thanks,
Tim
 
One problem is if you are using a Reserved word in your query, but if it's
working with ADO.NET and you haven't changed any of the fields, that's
probably not it. Are you sure you have permissions to access the file? Can
you fire an Update statement?
 
Thanks, it was that simple... when I copied everything to
my new machine I didn't give the ASPNET process write
access to the Access DB.

Thanks, all fixed.
Tim S.
 
Good to hear.
Tim S. said:
Thanks, it was that simple... when I copied everything to
my new machine I didn't give the ASPNET process write
access to the Access DB.

Thanks, all fixed.
Tim S.
Click to expand...
 
¤ Hello,
¤ I wrote ADO.Net code that given a Query Name and
¤ parameter array, ran the query with the parameters. The
¤ database was MS Access 2002.
¤ This code worked fine for 8 months under extreme
¤ testing and production use. I upgraded to Windows XP,
¤ installed VS.Net 2003, it now crashes saying "Operation
¤ must use an updateable query."
¤ The query *is* an updatable query (an Insert
¤ statement), and works perfectly fine when run from Access.
¤
¤ Does anyone know what could cause such an error?

I would be willing to bet that the permissions are different.

I don't know whether this is a VB.NET or ASP.NET application but insufficient permissions are likely
preventing you from working with the corresponding .LDB file.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top