Using Access for a web

Using Access for a web application data source has been challenging to say the least. Its security is unnecessarily confusing and is the cause of much frustration. The latest curse has been “Operation must use an updateable query.” You got to wonder who thinks up these meaningless messages. Perhaps it’s an ancient from the inquisition period.

The “Operation must use an updateable query.” message follows an attempt to update a table. A search of the internet found that many experience this problem and are as baffled as I on the cause. There are also many who offer solutions. I tried several with no success … until I stumbled onto Doug’s FAQs. Within seconds my problem was solved. All I did was grant USER full access to the directory containing my access mdb file. Thanks for the help Doug. I have added your site to my favorites list.