dotnet academic: I am using ASP.NET on a standalone system, running Win XP SP-1, with IIS 5.1. My 'aspx' page displays dynamic data from database but when i try to insert, it gives the error of 'must be updatable querry'. (80004005

My database is very simple test database (MS Access 2003) so no problem with referntial integrety
I have checked the read-only permissions on the mdb file.(though all the folders show this enabled)
I even transfered the file to shared documents, to a web shared folde
I also tried giving IUSR account the administrator privilages, but didnt work

"Abhishek Agarwal" <abhi_chemical(remove this)@rediffmail.com> wrote in
message news:4C9CB710-BED9-4672-B64B-02DF225C8E62@microsoft.com...
[quoted text, click to view]
5.1. My 'aspx' page displays dynamic data from database but when i try to
insert, it gives the error of 'must be updatable querry'. (80004005)
[quoted text, click to view]

Can you provide some specific information about the table(s) involved and
the query that is used to retrieve the data displayed? It would also help if
you could show the code snippet which attempts the insert and identify the
line that throws the error.
I am confused by your statement "I have checked the read-only permissions on
the mdb file.(though all the folders show this enabled)"
Do you mean that you have confirmed the file is not read-only?

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Hi Abhishek,

See http://www.webthang.co.uk/tuts/tuts_asp/gk_errors/gk_errors.asp#1 for
some possibel help.

bill b
"Abhishek Agarwal" <abhi_chemical(remove this)@rediffmail.com> wrote in
message news:4C9CB710-BED9-4672-B64B-02DF225C8E62@microsoft.com...
[quoted text, click to view]
5.1. My 'aspx' page displays dynamic data from database but when i try to
insert, it gives the error of 'must be updatable querry'. (80004005)
[quoted text, click to view]

I have seen this error in 2 cases:

1. When database file is read only
2. When the security settings prevent from modifying the file(database). In this case, go to explorer, right click on the file, select proeprties and go to the Security tab. If you really don't care about the security issues, select the user "Users" and sgive "Full Control".
Hope this will help.

- Tony


[quoted text, click to view]