Saturday, March 24, 2012

Operation must use an updateable query

Can anybody tell me what's wrong?
I can read the database, no problem
But when I try to insert something, i alsways got this error:

Operation must use an updateable query

I guess there is something wrong with the persissions?

I already give the folder (named data) where my access db is in write permissions in IIS

is this not enough?I would think it's a permission issue

Resolutions:

1. Give Internet Guest account (IUSR_MACHINE) Write permissions on the database file (.mdb).

2. Give read / write access databases by giving the local asp.net user account full privileges
My guess is You missed to give asp.net user account privilages. So this could be ther probelm!

Hope it helps!

0 comments:

Post a Comment