I set up a simple web application a few weeks ago and needed to make some changes. I made the changes on my laptop in Visual Studio and it works fine on my laptop. So I uploaded the entire project to the host server and now when I try to update or insert into my database I get this error:
Message: Operation must use an updateable query.
Native Error: -198839259
Source: Microsoft JET Database Engine
SQL State: 3073
I've seen this error before when I didn't give the aspnet account write access to the database. I did have this working fine on the host server before and can't think of what is causing this error. Anyone ever seen it before? Thanks.