Hello, I develop my web site using Visual Web Developer 2005, works perfectly runs under VWD (using ASP.NET Development Server), but when I run my site under IIS with NET Framework 2.0 aparently works fine but when I need UPDATE or INSERT data in my Access Database an error occurs:

System.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][Controlador ODBC Microsoft Access] La operación debe usar una consulta actualizable.

Please helpme I don't see the problem.

Thanks

Sounds like a security issue to me. Is it possible that the account your Web site runs under (ASPNET or Network Service) does not have permission to write to and read from the database?

Check out this FAQ: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=263

It's targeted at classic asp but I think it will work for you too.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.