I used the original code sample from http://www.willyd.ca and modified it to work with the Microsoft Access database. It includes membership management, link management, a blogging feature. I just finished the code changes.
I should be able to package it up pretty soon, if your interested. I just have to do some code clean-up.
I've deployed the site at http://www.thevalenzuelas.net and it only occurs (that I can tell) when I login using a username and password that is valid. If I use an invalid one, it tells me that my login attempt
was unsuccessful. I haven't seen it when doing any other actions.
I'm still a newbie and trying to decipher this error message, wondering if someone can help me put this into English?
Thanks....
++++++++++++++++++++++++++++++++++++=
Server Error in '/' Application.
Operation must use an updateable query.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Source Error:
Line 880: command.Parameters.Add(CreateDateTimeOleDbParameter("@LastLoginDate", DateTime.Now));
Line 881: command.Parameters.Add(new OleDbParameter("@UserId", userId));
Line 882: command.ExecuteNonQuery();
Line 883:
Line 884: command = new OleDbCommand(@"UPDATE aspnet_Users " +
You need to make sure the database has write access.
remvalenzuela
Hello, I'm having a different problem now.
I've deployed the site at http://www.thevalenzuelas.net and it only occurs (that I can tell) when I login using a username and password that is valid. If I use an invalid one, it tells me that my login attempt
was unsuccessful. I haven't seen it when doing any other actions.
I'm still a newbie and trying to decipher this error message, wondering if someone can help me put this into English?
Thanks....
++++++++++++++++++++++++++++++++++++=
Server Error in '/' Application.
Operation must use an updateable query.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Source Error:
Line 880: command.Parameters.Add(CreateDateTimeOleDbParameter("@LastLoginDate", DateTime.Now));
Line 881: command.Parameters.Add(new OleDbParameter("@UserId", userId));
Line 882: command.ExecuteNonQuery();
Line 883:
Line 884: command = new OleDbCommand(@"UPDATE aspnet_Users " +
I have posted an update to the Personal Starter Kit for MS Access on my website
http://www.VictorCorey.com. The Extended Personal Starter Kit for MS Access contains administration for links, photos, news, blogs, and users. The update is listed as the
Extended version.
hi , i can not send mail to users. i think we must add a smtp server address. bu how ? this is error code.
A from e-mail address must be specified in the From property or the system.net/mailSettings/smtp config section.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: A from e-mail address must be specified in the From property or the system.net/mailSettings/smtp config section.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): A from e-mail address must be specified in the From property or the system.net/mailSettings/smtp config section.]
System.Web.UI.WebControls.MailDefinition.CreateMailMessage(String recipients, IDictionary replacements, String body, Control owner) +1581
System.Web.UI.WebControls.LoginUtil.CreateMailMessage(String email, String userName, String password, MailDefinition mailDefinition, String defaultBody, Control owner) +169
System.Web.UI.WebControls.LoginUtil.SendPasswordMail(String email, String userName, String password, MailDefinition mailDefinition, String defaultSubject, String defaultBody, OnSendingMailDelegate onSendingMailDelegate, OnSendMailErrorDelegate onSendMailErrorDelegate, Control owner) +347
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPasswordQuestionView() +657
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPassword() +68
System.Web.UI.WebControls.PasswordRecovery.OnBubbleEvent(Object source, EventArgs e) +84
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +85
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4921
you have to set up the smtp server through the asp configuration. goto website on the menu and click asp.net configuration and you should see it from there.
You're so good. Have been struggling with my website and host for about 2 months now. Just realised today my host does not take SQL by MS Access (I am a newbie...). Downloaded your codes and it is working!!!!! I have NO error messages! I am sooo happpy!!!!!
Thank you again.
Will work on this base now and try to do someting nice!
victorcorey
Member
332 Points
104 Posts
Re: Personal Starter Kit for MS Access
Jun 16, 2006 03:07 PM|LINK
I used the original code sample from http://www.willyd.ca and modified it to work with the Microsoft Access database. It includes membership management, link management, a blogging feature. I just finished the code changes.
I should be able to package it up pretty soon, if your interested. I just have to do some code clean-up.
BravoOsca
Member
15 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 17, 2006 09:44 PM|LINK
It would be nice to have.. The one that you got is that in VB or in C#?
So im very interested.. I will try to take a look at the code, at http://www.willyd.ca, and maby i can learn something from it ;o)
remvalenzuel...
Member
15 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 19, 2006 04:05 AM|LINK
Hello, I'm having a different problem now.
I've deployed the site at http://www.thevalenzuelas.net and it only occurs (that I can tell) when I login using a username and password that is valid. If I use an invalid one, it tells me that my login attempt was unsuccessful. I haven't seen it when doing any other actions.
I'm still a newbie and trying to decipher this error message, wondering if someone can help me put this into English?
Thanks....
++++++++++++++++++++++++++++++++++++=
Server Error in '/' Application.
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Source Error:
Source File: d:\hosting\remvalenzuela\App_Code\csharp\AccessMembershipProvider.cs Line: 882
Stack Trace:
victorcorey
Member
332 Points
104 Posts
Re: Personal Starter Kit for MS Access
Jun 19, 2006 04:02 PM|LINK
You need to make sure the database has write access.
victor.corey
Member
40 Points
8 Posts
Personal Starter Kit for MS Access - Update has been posted
Jun 25, 2006 12:00 AM|LINK
Hello everyone,
I have posted an update to the Personal Starter Kit for MS Access on my website http://www.VictorCorey.com. The Extended Personal Starter Kit for MS Access contains administration for links, photos, news, blogs, and users. The update is listed as the Extended version.
Please let me know if you have any problems.
Thanks,
Victor Corey
http://www.VictorCorey.com
pacecal
Member
22 Points
5 Posts
Re: Personal Starter Kit for MS Access
Jul 31, 2006 05:11 PM|LINK
It works great!
I've a question, how do i edit my connectionstring. I've placed the access database in my domain:
mydomain.nl\db\ASPnetDB.mdb
serseri
Member
10 Points
2 Posts
Re: Personal Starter Kit for MS Access - Update has been posted
Aug 02, 2006 04:55 PM|LINK
hi , i can not send mail to users. i think we must add a smtp server address. bu how ? this is error code.
A from e-mail address must be specified in the From property or the system.net/mailSettings/smtp config section.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: A from e-mail address must be specified in the From property or the system.net/mailSettings/smtp config section.
Source Error:
Stack Trace:
noxignis
Member
50 Points
10 Posts
Re: Personal Starter Kit for MS Access - Update has been posted
Aug 24, 2006 02:23 AM|LINK
patricksy
Member
45 Points
9 Posts
Re: Personal Starter Kit for MS Access
Aug 27, 2006 01:28 AM|LINK
Hi there Victor,
I'm using your Extended kit. Just wonder how do i implement Dynamic Themes. Thanks
More Power...
banna75
Member
5 Points
1 Post
Re: Personal Starter Kit for MS Access
Sep 16, 2006 10:22 PM|LINK
Victor,
You're so good. Have been struggling with my website and host for about 2 months now. Just realised today my host does not take SQL by MS Access (I am a newbie...). Downloaded your codes and it is working!!!!! I have NO error messages! I am sooo happpy!!!!!
Thank you again.
Will work on this base now and try to do someting nice!
[:D]