Hi all,
I am a student learning ASP.net now. I need help with the problems that I am facing with editing and deleting records from the database (created Microsoft Access).
Currently, my .aspx page is able to retrieve and display records from tables in the database. However, as part of my school assignment, I also need to be able modify the data, i.e to add, edit and delete records, and that is when the errors occurs.
Whenever I try to carry out either of the add / edit / delete action, an exception was caught in the catch loop and it shows:
Error updating the database. Please make sure all values are correctly input.
System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at ASP.listing10_listing1010_aspx.ExecuteStatement(Object strSQL)
I have absolutely no idea what is going on as the exact same copy of codes and database are running perfectly fine in my school lab but it simply CANNOT run in my home machine (Windows XP).
Please advice me on what should I do.
Thanks alot!!! ~ michelle
Problems with modifying records from Database (VB.NET)
dgm2
Thanks for your reply. But I am still a little confused. What ASPNET user Who created that user and how did that user came about
And, where do I change the access right for the ASPNET user When I am in the school lab, I can find the security tab to modify the access rights of users of the computer, but I cant seems to find it in my home computer. Where and how do I get it out
Thanks!!
~mic
Derrick Morin
bfollenweider
The asp.net user is not being created in active directory on my 2003 server.
I have reinstalled .net 2.0. on this server, but it doesn't seem to be getting added automatically as suggested.
Can I/should I add this user manually
sotona
yes!!!! my page is finally working !!
thks a lot for your great help !!!
jim and ebby
The ASPNET user is created when you install the .NET framework. It is the user that all ASP.NET applications run under. This gives you the ability to limit the rights of that user, and therefore all ASP.NET applications (since you typically want such applications to have limited access).
To give the ASPNET user full access to your database, browse in Windows Explorer to the directory your database is in. Right-click on the directory (not the file) and click Properties. Select the Security tab and click Add. Type in ASPNET and click OK. The ASPNET user should be selected in the "Group or user names:" box. In the permissions box, click "Full Control", and click OK.
If you dont have an ASPNET user account, that could mean that IIS was installed on your home computer after the .NET framework. You will need to uninstall and reinstall the .NET framework.