All of the following accounts are a part of advauthor group: machine\ASPNET, IIS_GPM, IUSR_machine, IWAM_machine, and everything else is IIS_GPM group

advauthor group for files only can list folder read/data, read attributes, read extended attributes, create files/write data, create folders/append data, write attributes, write extended attributes, delete, read permissions.  The only thing it cannot do is delete subfolders and files, change permissions, and take ownership.  However, there are no deny permissions that are set for the advauthor group.

advauthor group for This folder and Subfolders are transverse folder/execute file as well as everything listed above.

When I try to write to the database I end up receiving the System.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. Error that so many people seem to get.  It seems like I've already done everything since the accounts all have read/write access for the database folder and for the database.

I've looked at a few Microsoft knowledge base articles that said to enable read and write permissions and I followed the steps to enable them. 

Hi, For the above Error.Please check the Data base permission(MDB File) .it is full control for every one. This may help you alot.I tested abd it is working fine

Hi,

For the above Error.Please check the Data base permission(MDB File) .it is full control for every one. This may help you alot.I tested abd it is working fine

Hi,

For the above Error.Please check the Data base permission(MDB File) .it is full control for every one. This may help you alot.I tested abd it is working fine

Thanks

Siva

Hello,

I too have the similar issue discussed in the forum but unable to sove it. Does anyone have a solution for the problem in Win 2003 OS? Has anyone got it working in Win 2003? Pls let me know the steps you had followed. The following are the things I had followed. Please correct me if I got it wrong anywhere.

 The MDB(Access) File resides in a Win 2003 server.

Both the MDB File and the folder containing the file have "Full Control" permission for user "Everyone"

The .NET program which makes an entry in the .MDB file(residing on the Win2003 server) uses the .NET Framework 2.0 and would be run on a Win 2000/ Win XP machine. 

When the program tries to make an entry in the .MDB file, i get the following error "...operation must be an updateable query..."

Any help would be greatly appreciated.

Try to "Remove" the Application.. and then "Create" after that, set permissions again to your app folder. Btw, this problem was really common to IIS 6.

Cheers,

CLIPER 

I am having the same problem as Bracoute. The same "Operation must be an Updateable Query" error message.

The others that solved the problem were so happy that forgot to tell what they exactly did.

I need some details and promise to tell what i did if eventually I will  be also happy.

federico

Sorry I did not yet read all replies!

thx Bachino. you're solution is the correct one - at least it was the one that solved one of my permissions problems.

You must prefix ASPNET with the computer name that you're dealing with.

I too faced the above problem. In my server permission had not been made to update. Once permission was granted for update it worked well.

sponsored link

http://www.articlescloud.com

Rkiser1958:

I am having the same problem except my code works fine on my computer using IIS, now that I have it on the web using a Web Hosting service (on a windows server) all of the "search" commands work but when I try to insert data I get the error:

Server Error in '/' Application.

Operation must use an updateable query.

and one of the lines in my code is highlighted

"SqlDataSource1.insert()"                it says SqlDataSource but it is configured using an Access Data source.

Like I said it works fine on my computer when I created a virtual directory using IIS.

Now is the problem with my code or on the server side.

If you had read through the posts in this thread, you would have found that the cause of the error is insufficient permissions. On WinXP, the ASPNET account needs Modify permissions on the folder containing the database file.  On Win 2k3, it's the NETWORK SERVICE account.

I was sure it was on the Server side, and I finally got someone to fix it.

Thanks

Hi Henrix,

this is naveen 

Query = "insert into PlayerInfo (Name,Email,CharacterName) values ('" & NameBox.Text '," & MailBox.text & "','" & CNameBax.text & "')"

in tha above query u missed the single quatation near mailbox.text keep the quatation and try it once