I am new to .NET and I too have been trying to work with the Personal Starter Kit as a learning tool. Unfortunately, my host does not allow the user of SQL Express 2005 and SQL Server will cost extra.
I converted the "personal" database into MS Access and then used the Sample Access Provider Starter Kit to modify the Login controls to use a MS Access database. Now the project runs on two MS Access databases.
You should download and open the PersonalStarterKitMSAccess.vsi file and it will install a zip file (Personal Start Kit MS Access.zip) in the
C:\Documents and Settings\[user]\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual C# directory.
Then when you start VWD Express and goto: File > New Website... You should see a template for Personal Start Kit MS Access.
Hope this helps. I was able to create a website from the template and everything works fine. But, I am new to this so I could have done something wrong.
This is the error I get "Installation stopped because the directory for the ProjectType value did not exist. The project type is invalid for your installation of Visual Studio."
I managed to extract your code but failed in using the default way to install it.
The problem you're facing is because you need to have Visual C# Express installed in your computer in order to complete the installation. I had the same problem. It was until I downloaded and installed VS C# that the installation worked.
Thank you so much for your effort by putting up this starter kit. I installed it and it show no sign of failing. But i can't see it from "new project" under C# express. I unzip the file manually and tried to open it as a web project. there is no .csproj
file at the root. However there is an empty .webproj file i don't know how VS will recognize this. please advice how should i use it from here.
You shouldn't need to unzip the file. When you install the .vsi file, it should put the .zip file in the
C:\Documents and Settings\[user]\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual C# directory. I am using VWD Express. I'm not sure if that is different than C# Express.
Once I installed it, I restarted VWD Express and when I create a new project that is one of the options.
I am new to .NET and I too have been trying to work with the Personal Starter Kit as a learning tool. Unfortunately, my host does not allow the user of SQL Express 2005 and SQL Server will cost extra.
I converted the "personal" database into MS Access and then used the Sample Access Provider Starter Kit to modify the Login controls to use a MS Access database. Now the project runs on two MS Access databases.
I am net to .NET too. Thank you for this MS Access version of the tool kit. About to upload to the hosting webserver, but I am wondering how the connectionstring should look like in order to be able to connect to the provided access databases. Thank you
in advance and pls forgive my ignorance in .NET.
I am net to .NET too. Thank you for this MS Access version of the tool kit. About to upload to the hosting webserver, but I am wondering how the connectionstring should look like in order to be able to connect to the provided access databases. Thank you in
advance and pls forgive my ignorance in .NET.
Thanks
I don't think you should have to change the connectionstring at all. I believe the
Data Source=|DataDirectory|. References the App_Data directory.
I modified the .vsi file to hopefully fix the installation problems. The template should now be installed here:
C:\Documents and Settings\{user}\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual Web Developer\Personal Starter Kit MS Access.zip
Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\<--path to website-->\Upload'.
Line 348: DirectoryInfo d = new DirectoryInfo(System.Web.HttpContext.Current.Server.MapPath("~/Upload")); Line 349: //DirectoryInfo d = new DirectoryInfo("c:\\Upload"); Line 350: return d.GetFileSystemInfos("*.*"); Line 351: } Line 352:
Unfortunately, I have only run the application locally. I am still working on some more modifications. I would think if you modify the code in the
App_Code directory (ex. AccessConnectionHelper.cs, AccessMembershipProvider.cs, etc.) by changing the references from
System.Data.OleDb to
System.Data.Odbc.
It would be a very tedious task, but I would think that should work.
Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\<--path to website-->\Upload'.
Line 348: DirectoryInfo d = new DirectoryInfo(System.Web.HttpContext.Current.Server.MapPath("~/Upload")); Line 349: //DirectoryInfo d = new DirectoryInfo("c:\\Upload"); Line 350: return d.GetFileSystemInfos("*.*"); Line 351: } Line 352:
Source File: PhotoManager.cs Line: 350
Hmmm...
This sounds like a stupid question, but do you have the Upload directory in the root of your site? If so, I believe it needs read/write access.
This sounds like a stupid question, but do you have the Upload directory in the root of your site? If so, I believe it needs read/write access.
Actually that was the problem. The install didn't have the folder and I needed to add it manually. Unfortunately, there 's no way to delete posts in this forum so I couldn't remove my earlier post.
thanks for responding and reminding me to post again.
Actually that was the problem. The install didn't have the folder and I needed to add it manually. Unfortunately, there 's no way to delete posts in this forum so I couldn't remove my earlier post.
thanks for responding and reminding me to post again.
No worries... I will take a look at the installer and fix the missing directory.
I hve installed your Personal Starter Kit for MS Access and it works fine on Visual Web Developer but when running live I can't log in.
If I type a wrong userid/pwd the error message appears. When I type the right userid/pwd nothing happens (It doesn't display Welcome <userid>...any idea?
The starter kit works on my local server fine, but unfortunately when I put it on the remote server I get the following error:
Server Error in '/' Application.
Runtime Error
Description:
An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local
server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors>
tag should then have its "mode" attribute set to "Off".
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
[:(] I have changed it but I still get the same error.
could you tell me the reason?
You might have a stray character or incorrect syntax in Web.config, which could be a possible reason why you're still getting that after setting customErrors mode="Off". Double check Web.config and make sure that everything
looks OK.
I just finished the conversion to VB. Actually the Membership Provider is still in C#, but the rest of the site is in VB. I just have to package it up. I will hopefully put it up tomorrow.
Just let your know that I use some of your C# AccessHelper code for my site at
http://www.edream.org. It works great! I recommend you to everyone that don't have sql server.
I have to give credit to this forum and the people on it. I've learned quite a bit from pulling apart the Starter Kit and getting answers from the people here. The forum for VB.NET and the Amazon Movie VB Starter Kit is not well organized at all.
Just let your know that I use some of your C# AccessHelper code for my site at
http://www.edream.org. It works great! I recommend you to everyone that don't have sql server.
I am new to ASP and must be doing something stupid. I have loaded the Personal starter kits for access (Both the C# and VB) and I get them to work in Visual Studio. My problem is when running the site on the web server I get the following error message.
Do you have any ideas what I am doing wrong?
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Line 1: <?xml version="1.0"?>
Line 2: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
Line 3: <connectionStrings>
Line 4: <add name="Personal" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Personal.mdb;" providerName="System.Data.OleDb"/>
I am new to ASP and must be doing something stupid. I have loaded the Personal starter kits for access (Both the C# and VB) and I get them to work in Visual Studio. My problem is when running the site on the web server I get
the following error message. Do you have any ideas what I am doing wrong?
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file
appropriately.
Line 1: <?xml version="1.0"?>
Line 2: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
Line 3: <connectionStrings>
Line 4: <add name="Personal" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Personal.mdb;" providerName="System.Data.OleDb"/>
When I try to open the vsi file I get an error that the file is corrupted.
I'm using VS2005 Basic Edition (V8.0.50727) and have C# language installed.
I have the Personal Web Site running with SQLExpress on my host but would like to use MS Access since I'm more familiar with it. Also, managing SQLExpress databases on a remote host is damn near impossible.
When I try to open the vsi file I get an error that the file is corrupted.
I'm using VS2005 Basic Edition (V8.0.50727) and have C# language installed.
I have the Personal Web Site running with SQLExpress on my host but would like to use MS Access since I'm more familiar with it. Also, managing SQLExpress databases on a remote host is damn near impossible.
Hello johnsi,
Sorry about that. I was updating my website last night and somehow the files got corrupted. I have updated the files. You will need to download them again.
I am new to asp.net 2.0. I need to use ms access instead of sql express as well. I downloaded your kit, which is running well.
You said "I just used the Sample Access Provider from Microsoft". May i know your steps to integrate this to your kit?
I have a site with sql express already, so it is difficult to use your template at this point. I am trying to find an easy way to use ms access for those login controls in asp.net 2.
I developed a web with ms access db for membership (my host company supports this only) based on victor's example.
So I uploaded files to the server.
Without loading dll, I got this:
Parser Error Message: Could not load type 'AccessProviders.AccessMembershipProvider'.
Host company said they may not support this provider, but I suspect they do not support asp.net 2.0 website config. They provide the following example to access DB in asp.net 2.0:
string sPath = "C:\\sites\\single??\\username\\database\\YourDB.mdb";
string strConnection = ("Provider=Microsoft.Jet.OleDb.4.0;Data Source="
+ (sPath + ""));
string sSQL = "Select * from tablename";
Data.OleDb.OleDbConnection objConnection = new Data.OleDb.OleDbConnection(strConnection);
Data.OleDb.OleDbCommand objCommandAuction1 = new Data.OleDb.OleDbCommand(sSQL, objConnection);
Data.IDataReader oDr;
try {
objConnection.Open();
oDr = objCommandAuction1.ExecuteReader();
while (oDr.Read) {
// Write information from database here
}
oDr.Close();
}
catch (Exception ex) {
Response.Write(ex.Message);
}
objConnection.Close();
I have a small problem, when i CTRL+F5 in Visual studio everything work, and i can login with my account i have made. But when i try on the webserver where i uploaded the same code, then i can't login? I can see that it should work, because if I choose a
wrong password, it says that it was wrong, but when i choose the right one, I just get an empty page.
I'm a newbie to this ASP.NET stuff. Want to learn and have downloaded Victor's version of the starter site using VB and Access. I seem to have two issues (be gentle, I'm a newbie) BTW, both of these worked when I had the original version of the asp.net
starter site.
First, after installing the site, I click CTRL - F5 and get this error:
Unknown
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.
Line 94: lookupCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName));
Line 95:
Line 96: object lookupResult = lookupCommand.ExecuteScalar();
Line 97: if ((lookupResult != null) && (lookupResult is int)) {
Line 98: return (int)lookupResult;
Secondly, I cannot set up an administrator account for the site. I go to "website" -> ASP.NET Configuration -> Security and I get this error message:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to
a page where you can choose a new data store."
If I then go to "Choose Data Store" and then to "Select a single provider for all site management data" it says "no providers created" how do I create it... is it talking about an ODBC driver?
Dude this post saved my life today...Argh! It's so hard to work with SQLExpress on a development machine...I thought it was just gonna be a plug and play kind of thing...but it was hell =)
So thanks again for posting that.
Based on my usage of it it took a little tweaking to get it to run in my SurveyCenter application (for instance I had to modify the Application name table, and clear out the old entries. Then I had to fiddle with the Configuration Manager tool site for a bit...at
first it didn't work but after a few restarts it worked...the rest was modifying web.config.
Then I uploaded and Whammo! It didn't work :)
Then I did some more surfing, and sacrificing to the gods...then finally I found out that you have to tell your host to give the database folder, and all databases in it read/write/modify permissions...
I'm a newbie to this ASP.NET stuff. Want to learn and have downloaded Victor's version of the starter site using VB and Access. I seem to have two issues (be gentle, I'm a newbie) BTW, both of these worked when I had the original version of the asp.net
starter site.
First, after installing the site, I click CTRL - F5 and get this error:
Unknown
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.
Line 94: lookupCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName));
Line 95:
Line 96: object lookupResult = lookupCommand.ExecuteScalar();
Line 97: if ((lookupResult != null) && (lookupResult is int)) {
Line 98: return (int)lookupResult;
Secondly, I cannot set up an administrator account for the site. I go to "website" -> ASP.NET Configuration -> Security and I get this error message:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to
a page where you can choose a new data store."
If I then go to "Choose Data Store" and then to "Select a single provider for all site management data" it says "no providers created" how do I create it... is it talking about an ODBC driver?
Not sure what was different, but I whiped the O/S and had to install all of this on another machine and now that I try it, it all works. Not sure what was different.
Got it working, i talked to the company that host my side, and they change the rights on the server, so now everything is working.
Again, thanx for a great job on this project.
Right now im trying to make a page that i can use as contol of members and roles.
Can i use the "AccessMembershipProvider.cs" and "AccessRoleProvider.cs" for this?
I have tryed ObjectDataSource, but i get an error, so i probaly did something wrong. But i have to use the "AccessMembershipProvider.cs" or am i wrong?
Yes, you should be able to use the Access Providers. There are some limitations to the providers that are referenced in the readme. See below:
All providers
-------------
None of the providers support the "commandTimeout" attribute. The providers issue OleDb commands using
the default timeout for OleDbCommand(s) which is 30 seconds.
The providers all carry out read and write operations against the $safeprojectname$ database using the security
credentials associated with the current request. Unlike the built-in providers, the sample providers do
not suspend impersonation when client impersonation is in effect. This means one of the following
identities requires Read/Write access to the App_Data directory:
1. The worker process identity if no impersonation is used.
2. The application impersonation identity if <identity impersonate="true" user="userid" password="pwd" /> is used.
3. Each client identity if <identity impersonate="true" /> is used.
Parameter validation and syntax checking of parameters is current as of ASP.NET 2.0 Beta 1. As a result
the parameter validations used in Beta 2 and RTM providers will differ slightly from the validations
enforced by the $safeprojectname$ providers.
Membership
----------
Password strength requirements are not enforced in the CreateUser and ChangePassword methods. The settings are
read from configuration, but at are not used by the provider.
Account lockouts are not implemented in the provider. The UnlockUser method has no effect, and the provider
does not count bad password or bad password answer attempts.
The $safeprojectname$ provider does not support creating a new user with an explicit UserId (i.e. providerUserKey).
The $safeprojectname$ provider does not support retrieving a user based on UserId (i.e. providerUserKey).
Role Manager
------------
No known limitations.
Profile
-------
Marking Profile properties with "serializeAs=binary" will not work in partial trust web applications. Since
the sample provider does not assert any serialization permission (it can't since the sample provider is not
inside of System.Web.dll), the demand for serialization permission will fail in High trust or lower.
Web Parts Personalization
-------------------------
No known limitations.
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!
Has anyone run into problems displaying images? On my local server everything runs great but on my web host only a part of the image is displayed. No errors messages just a partial picture.
if url is empty this is error occuring... users must add an url when adding a talkback entry.
command.ExecuteNonQuery()
Line 86: Catch ex As Exception
Line 87: Throw New Exception("Error thrown in AddTalkBackEntry)", ex.InnerException)
Line 88: Finally
Line 89: If Not (connection Is Nothing) Then connection.Close()
I am one of the many grateful newbies who relied on you to get started with Access in asp.net. thank you.
One question if i may.
You use ObjectDataSource in your site and i wondered why you did so rather than the (apparently) simpler AccessDataSource?
I suspect the ODS is more fundamental than the ADS but there seemed to be advantages for newbies in avoiding the connectionstring.
Info is at http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.accessdatasource.datafile.aspx but it did take some finding. when MS does not want you to use a product they certainly know how to get their own way!
I am really happy with your Extended PWS. It is simply great, especially for the new options. Now I am figuring out how to make it working on both MS Access and SQL Server. I have a little web site where I put just a few pictures and it works perfect but
now my "extended" family want me to create a site for all of them (around 100 people) and I am afraid that MS Access will not be the right solution.
I tried to import the MS Access database into a new "personal" SQL Server database but it copied the views as tables and did not copy the queries. With this results, I did not even try to copy ASPNetDB. How can I change back the database engine?
(I know, it sounds crazy but it happens with a so successful product!)
Thanks a lot!
.NET 2.0database hostingPersonal web site Sql Server 2005personalkitstarter
I just wanted to say thank you also. I downloaded sql express but can't get the sql application to connect. I tried various "tips" from this site and others. Then I found your thread, read all the posts, downloaded the file, unzipped it and am already adding
photos and working with the administration.
It is so refreshing to find something that works "out of the box." I can't wait to personalize the site!
Cheers,
SMc[cool]
"I have not failed. I just found 10,000 ways that don't work." - Thomas Edison
I am really excited about this Starter Kit but I was wandering if there is someone out there who changed this "Personal Starter Kit for MS Access" To save album pictures on the filesystem instead of the Access database.
For me it seems a more simple solution and gives me the possibility to change, update pictures via FTP.
Thanks for the Access version of this template. Being new to this Visual basic, I am having trouble posting my site. Everything seems to work fine on my computer but when I move it to the hosting provider I have had noting but trouble. For a while the front
end worked but not the back. I changed the Data folder to write access and now I get nothing. The front end is not even appearing. I am now getting this message.
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load type 'AccessProviders.AccessRoleProvider'.
Source Error:
Line 39: <roleManager enabled="true" defaultProvider="AccessRoleProvider" cacheRolesInCookie="true" cookieName=".ASPXROLES" cookieTimeout="30" cookiePath="/" cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="All"> Line 40: <providers> Line 41: <add name="AccessRoleProvider" type="AccessProviders.AccessRoleProvider" connectionStringName="PersonalAccessProvider" applicationName="personalSite"/> Line 42: </providers> Line 43: </roleManager>
Would you have any suggestions on what could be doing this?
I have even tried removing and reinstalling everything on the hosting server to try to get the front end working again and nothing.
Thanks
Error.NET 2.0ASP.NET MembershipdatabasePersonal web site Sql Server 2005personal
hello sir I have downloade the program which u gave as link sir i dont know how to insert the image in MS access file can u guid me sir it is very urgent for me... sir.. plz reply me its realy very urgent for me.....
inbarajdurai@aol.com i hope i will get a reply
You don't insert the image into MS Access. That's the beauty of this application. Save your images to the Upload folder. If your site is remote (you have the site hosted on someone else's server) then you will have to publish the Upload folder.
Then, go to your live website, logon so you can use the administration features. Now go to the Manage link, pick albums. Create a new album and then click the Edit button. Now you can use the contents of the Upload folder (which should show on the left side
of the webpage "Bulk Upload Photos") to add to the album.
Or, you can create a new album and upload each photo one at a time via the same page under the "Add Photos" section.
Check out my site: seanmcgriff.net
Good luck!
"I have not failed. I just found 10,000 ways that don't work." - Thomas Edison
If you want to have this application go live on the internet, you will have to use a hosting service that has the .net framework available. You DO NOT have to have a license, since the .net framework is a free download. Again, the server that hosts your
site will need to have it!
Good luck.
"I have not failed. I just found 10,000 ways that don't work." - Thomas Edison
I just would like to thank you for making the extended version available for all to use. Since I'm just learning this has saved me countless hours.. I do have a question. I'm trying to add a table so that the site owner can log in and change the content
of the Default.aspx page . I can't seem to get this to work. The only option I get when trying to add a table to the personal.mdb is for a new query not add new table. Can you please tell me what I'm doing wrong.
I have been very happy with www.hostingfest.com. It's very inexpensive for the hosting and domain name. I am not affiliated with them, just satisfied with their hosting. I found them through a link on this home page,
under Featured ASP.NET web hosting.
"I have not failed. I just found 10,000 ways that don't work." - Thomas Edison
I just published the extended personal starter kit and I must say, it's nice to see modified code out there without any serious bugs. I am somewhat new with asp.net and thought the kit would be a great way to learn more about .net. I have a question concerning
the email feature. My hosted site does not have a mail server on the hosted site server. I was told I could use and ip address to get to the mail server. I've searched through the extended personal starter kit for ms access and cannot find where to modify
email configurations. Can anyone tell me where the ip address to get the email feature working? Thanks, Jim
Thank you so much Victor. That did it! It appears the only thing left is to incorporate the video page like your site has and modify some of the css files. I love this product and can't thank you enough.
Hi Victor I have a question regarding the extended personal starter kit. There are two page files, one concerning the password and the other, security question can you explain what your plan was for these pages. I see that they are in the root of the site
I would have though that they would have been placed in the admin folder with of course admin permissions. Unless they were there for learning purposes and expecting the user to place them there in the admin folder themself. I'm a bit confused can you please
instruct me in their purpose I don't see them in the sitemap. I ask only because I am a novice user of asp.net and like to ask questions before dive in to things. Thank you for your time.
I think you are talking about the RecoverPassword.aspx and ChangeSecurityQuestion.aspx pages. It has been sometime since I have looked at the codebase from the default install, so I'm not sure if these were implemented. These pages are for users to recover
their password and change their security question once logged in that is why they are not in the admin folder. The RecoverPassword is linked from the homepage just below the login form and the ChangeSecurityQuestion is linked from the Profile section once
logged in.
i saw all of the post nd most of the people works fine , but for me i facing the installation problem . When i double click the personalStarterKitMSAccess.vsi, it shows a error msg , "String cannot have zero length " ,currently i am using visual studio 2008
Professional Edition . How can i solve this problem?
Much thanks to Victor as well. Great job! I can host the website just fine with GoDaddy. The issue I run into is with the connection string. The default connection string in the Extended Kit is the following:
I think on any other host this would work. On GoDaddy, however; they require you to put your Access Database in their access_db folder that is created when you setup using an Access Database. The problem here is the DataDirectory part in Source=|DataDirectory|Personal.mdb;
for example. Based on the following website:
the DataDirectory folder refers to the App_Data folder which is where a database would be by default but NOT with GoDaddy.
My question is simple: how do I use the Extended Kit with GoDaddy with an Access Database? Is this even possible? I think I can use this connection string if I refer to the access_db folder instead of the App_Data folder. How do I do that? Help here would
be much appreciated. Thanks in advance.
Kevin
connection stringsGoDaddyPersonal Web Site Starter KitGoDaddy connection stringsMicrosoft AccessAccess
Wow. This is awesome! Thanks so much. Had no problems. Just do an Open Web Site within VS2005, and works every time!
Was even able to modify the entire application and db to store pics on a file system instead of inside the MS Access DB, which was getting very large. I store the pic's path as a string in the DB. Works great.
Thanks so much!
Personal Starter Kit ASP.NET Web Site Administration Tool
I, too, have godaddy and use this setup. I bypass the godaddy setup of having to put the access db file in their access_db folder. I have found that the MS Access DB file doesn't have to reside in the access_db folder. I completely ignore this folder and
place my Access DBs wherever I desire. I just ensure the godaddy folder that houses my Access DB file has write permissions. My godaddy access_db folder is actually empty right now :)
My personal.mdb lives in the App_Data folder as the kit suggested. I never touched the kit's default settings. I loaded the kit on my local machine, ensured it worked, then just uploaded all the files from my local machine to my godaddy website, and it
just always has worked.
Were you able to change the web.config settings in the kit to accomodate the godaddy access_db folder? This would be great info to know.
The only problems I've had so far are the permissions management. That doesn't work. I have another site in our company's intranet that uses SQL w/VB.net and everything works fine.
SMc
"I have not failed. I just found 10,000 ways that don't work." - Thomas Edison
None
0 Points
8 Posts
Personal Starter Kit for MS Access
Nov 30, 2005 08:40 PM|victor.corey|LINK
I am new to .NET and I too have been trying to work with the Personal Starter Kit as a learning tool. Unfortunately, my host does not allow the user of SQL Express 2005 and SQL Server will cost extra.
I converted the "personal" database into MS Access and then used the Sample Access Provider Starter Kit to modify the Login controls to use a MS Access database. Now the project runs on two MS Access databases.
I have created a template file for you to use:
http://www.victorcorey.com/PersonalStarterKitMSAccess.vsi
Please let me know if there are any problems.
Thanks,
VC
None
0 Points
31 Posts
Re: Personal Starter Kit for MS Access
Dec 01, 2005 01:11 AM|jackli|LINK
None
0 Points
8 Posts
Re: Personal Starter Kit for MS Access
Dec 01, 2005 11:14 AM|victor.corey|LINK
No, I am using VWD Express.
You should download and open the PersonalStarterKitMSAccess.vsi file and it will install a zip file (Personal Start Kit MS Access.zip) in the C:\Documents and Settings\[user]\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual C# directory.
Then when you start VWD Express and goto:
File > New Website...
You should see a template for Personal Start Kit MS Access.
Hope this helps. I was able to create a website from the template and everything works fine. But, I am new to this so I could have done something wrong.
None
0 Points
31 Posts
Re: Personal Starter Kit for MS Access
Dec 01, 2005 09:32 PM|jackli|LINK
This is the error I get "Installation stopped because the directory for the ProjectType value did not exist. The project type is invalid for your installation of Visual Studio."
I managed to extract your code but failed in using the default way to install it.
None
0 Points
27 Posts
Re: Personal Starter Kit for MS Access
Dec 08, 2005 01:57 PM|carlone|LINK
Jackli,
The problem you're facing is because you need to have Visual C# Express installed in your computer in order to complete the installation. I had the same problem. It was until I downloaded and installed VS C# that the installation worked.
Best Regards,
Carlos Lone
http://blog.contoso.net/dotnetmaniagt
Member
30 Points
231 Posts
Re: Personal Starter Kit for MS Access
Dec 16, 2005 12:01 PM|suegooge|LINK
Victor,
Thank you so much for your effort by putting up this starter kit. I installed it and it show no sign of failing. But i can't see it from "new project" under C# express. I unzip the file manually and tried to open it as a web project. there is no .csproj file at the root. However there is an empty .webproj file i don't know how VS will recognize this. please advice how should i use it from here.
Your time is highly appreciated!
Sue
Member
30 Points
231 Posts
Re: Personal Starter Kit for MS Access
Dec 16, 2005 02:57 PM|suegooge|LINK
Never mind, I found a way to work around it and it works perfectly fine. Thanks so much for Victor for your genorous sharing.
Sue
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 16, 2005 03:05 PM|victorcorey|LINK
Sue,
You shouldn't need to unzip the file. When you install the .vsi file, it should put the .zip file in the C:\Documents and Settings\[user]\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual C# directory. I am using VWD Express. I'm not sure if that is different than C# Express.
Once I installed it, I restarted VWD Express and when I create a new project that is one of the options.
Hope this helps.
Victor
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access
Dec 17, 2005 05:42 AM|jimmy_au|LINK
I am net to .NET too. Thank you for this MS Access version of the tool kit. About to upload to the hosting webserver, but I am wondering how the connectionstring should look like in order to be able to connect to the provided access databases. Thank you in advance and pls forgive my ignorance in .NET.
Thanks
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 19, 2005 12:58 PM|victorcorey|LINK
I don't think you should have to change the connectionstring at all. I believe the Data Source=|DataDirectory|. References the App_Data directory.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 21, 2005 10:41 AM|victorcorey|LINK
I modified the .vsi file to hopefully fix the installation problems. The template should now be installed here: C:\Documents and Settings\{user}\My Documents\Visual Studio 2005\Templates\ProjectTemplates\Visual Web Developer\Personal Starter Kit MS Access.zip
http://www.victorcorey.com/PersonalStarterKitMSAccess.vsi
Please let me know if there are any problems with the file.
Thanks,
VC
None
0 Points
10 Posts
Re: Personal Starter Kit for MS Access
Dec 24, 2005 03:32 AM|richisieber|LINK
Hello vitorcorey
Congratulations your access version modification works perfectly [:)]
Have you ever tied to run the application on ODBC ?
The reaseon is, that most host providers requesting only this type of connection.
Yersterday I made my first experiance.
I downloaded the newest MS Odbc assembly. After installing I changed all Oledb to Odbc.
In web.config added two DSN entries for Personal and AspNetDb.
When I compile, I get several errors, because from Namespace: Microsoft.Data.Odbc
most Types are not supported ! [:(]
Do you know any solution to fix this problem?
Best would be in web.config
Wish you happy Xmas
Richard
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 28, 2005 12:25 PM|victorcorey|LINK
Unfortunately, I have not tried. I would think your idea is correct. You may also have to change the connectionstring.
None
0 Points
10 Posts
Re: Personal Starter Kit for MS Access
Dec 28, 2005 01:50 PM|richisieber|LINK
Hello victorcorey
Its' not as simple as it looks like, because the aspnetdb provider which is developed in C+ + have other types as we expect in C# !
Does your application run on a server ?
How did you manage it ?
Richard
Member
20 Points
448 Posts
Re: Personal Starter Kit for MS Access
Dec 28, 2005 01:57 PM|webber123456|LINK
Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\<--path to website-->\Upload'.
Line 348: DirectoryInfo d = new DirectoryInfo(System.Web.HttpContext.Current.Server.MapPath("~/Upload"));Line 349: //DirectoryInfo d = new DirectoryInfo("c:\\Upload");
Line 350: return d.GetFileSystemInfos("*.*");
Line 351: }
Line 352:
Source File: PhotoManager.cs Line: 350
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 29, 2005 10:36 AM|victorcorey|LINK
Unfortunately, I have only run the application locally. I am still working on some more modifications. I would think if you modify the code in the App_Code directory (ex. AccessConnectionHelper.cs, AccessMembershipProvider.cs, etc.) by changing the references from System.Data.OleDb to System.Data.Odbc.
It would be a very tedious task, but I would think that should work.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 29, 2005 01:53 PM|victorcorey|LINK
Hmmm...
This sounds like a stupid question, but do you have the Upload directory in the root of your site? If so, I believe it needs read/write access.
Member
20 Points
448 Posts
Re: Personal Starter Kit for MS Access
Dec 29, 2005 06:18 PM|webber123456|LINK
Actually that was the problem. The install didn't have the folder and I needed to add it manually. Unfortunately, there 's no way to delete posts in this forum so I couldn't remove my earlier post.
thanks for responding and reminding me to post again.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Dec 29, 2005 07:13 PM|victorcorey|LINK
Sorry about that.
VC
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jan 01, 2006 11:29 AM|kretzmann|LINK
Hi,
I hve installed your Personal Starter Kit for MS Access and it works fine on Visual Web Developer but when running live I can't log in.
If I type a wrong userid/pwd the error message appears. When I type the right userid/pwd nothing happens (It doesn't display Welcome <userid>...any idea?
Regards Peter
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jan 02, 2006 02:12 AM|kretzmann|LINK
I found the error. When I Web Alias to redirect my domain it didn't work but when I switched it to Web Forward it works fine.
Kretzmann
None
0 Points
11 Posts
works localy not remotely
Jan 24, 2006 02:45 AM|aymanh5|LINK
The starter kit works on my local server fine, but unfortunately when I put it on the remote server I get the following error:
Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="Off"/> </system.web> </configuration>Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/> </system.web> </configuration>Can enybody help?
Contributor
6294 Points
5754 Posts
ASPInsiders
Re: works localy not remotely
Jan 24, 2006 03:49 AM|StrongTypes|LINK
Make sure that the customErrors node of Web.config has mode set to Off so you can see the runtime error.
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
None
0 Points
11 Posts
Re: works localy not remotely
Jan 24, 2006 05:39 AM|aymanh5|LINK
[:(] I have changed it but I still get the same error.
could you tell me the reason?
None
0 Points
64 Posts
Re: Personal Starter Kit for MS Access
Jan 26, 2006 10:31 PM|rgibson69|LINK
Does anyone know if this has been converted to VB?
Does anyone know if this can be converted to VB (if not why)?
I have an application that may benefit from this.
Rob
rgibson@robgibson.ca
www.robgibson.ca
Contributor
6294 Points
5754 Posts
ASPInsiders
Re: works localy not remotely
Jan 26, 2006 10:59 PM|StrongTypes|LINK
[:(] I have changed it but I still get the same error.
could you tell me the reason?
You might have a stray character or incorrect syntax in Web.config, which could be a possible reason why you're still getting that after setting customErrors mode="Off". Double check Web.config and make sure that everything looks OK.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jan 26, 2006 11:53 PM|victorcorey|LINK
Hello Rob,
I just finished the conversion to VB. Actually the Membership Provider is still in C#, but the rest of the site is in VB. I just have to package it up. I will hopefully put it up tomorrow.
Thanks,
Victor
Member
30 Points
231 Posts
Re: Personal Starter Kit for MS Access
Jan 27, 2006 09:37 AM|suegooge|LINK
Victor,
Just let your know that I use some of your C# AccessHelper code for my site at http://www.edream.org. It works great! I recommend you to everyone that don't have sql server.
Sue
None
0 Points
64 Posts
Re: Personal Starter Kit for MS Access
Jan 27, 2006 09:43 AM|rgibson69|LINK
Thanks Victor. Your work is much appreciated.
I have to give credit to this forum and the people on it. I've learned quite a bit from pulling apart the Starter Kit and getting answers from the people here. The forum for VB.NET and the Amazon Movie VB Starter Kit is not well organized at all.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jan 27, 2006 12:00 PM|victorcorey|LINK
The MS Access conversions can be found here:
C#: http://www.victorcorey.com/personalStarterKitMSAccess.vsi
VB: http://www.victorcorey.com/personalStarterKitMSAccessVB.vsi
Please let me know if there are any problems.
Thanks,
Victor
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jan 27, 2006 12:05 PM|victorcorey|LINK
Hello Sue,
Thank you. Although, I can not take the credit. I just used the Sample Access Provider from Microsoft (http://msdn.microsoft.com/asp.net/downloads/providers/default.aspx).
Your site looks great.
Thanks,
Victor
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jan 30, 2006 11:28 AM|KC78|LINK
Victor,
I am new to ASP and must be doing something stupid. I have loaded the Personal starter kits for access (Both the C# and VB) and I get them to work in Visual Studio. My problem is when running the site on the web server I get the following error message. Do you have any ideas what I am doing wrong?
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Unrecognized attribute 'xmlns'.
Source Error:
Line 1: <?xml version="1.0"?>
Line 2: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
Line 3: <connectionStrings>
Line 4: <add name="Personal" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Personal.mdb;" providerName="System.Data.OleDb"/>
Source File: C:\Inetpub\wwwroot\asptestsite\web.config Line: 2
Thanks,
KC78
Contributor
6294 Points
5754 Posts
ASPInsiders
Re: Personal Starter Kit for MS Access
Jan 30, 2006 03:36 PM|StrongTypes|LINK
Victor,
I am new to ASP and must be doing something stupid. I have loaded the Personal starter kits for access (Both the C# and VB) and I get them to work in Visual Studio. My problem is when running the site on the web server I get the following error message. Do you have any ideas what I am doing wrong?
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Unrecognized attribute 'xmlns'.
Source Error:
Line 1: <?xml version="1.0"?>
Line 2: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
Line 3: <connectionStrings>
Line 4: <add name="Personal" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Personal.mdb;" providerName="System.Data.OleDb"/>
Source File: C:\Inetpub\wwwroot\asptestsite\web.config Line: 2
Thanks,
KC78
Are you trying to deply it on .NET 1.1? That is what that error makes it look like.
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jan 30, 2006 03:46 PM|KC78|LINK
Your right. ASP.NET 2.0 was loaded on the server but it was not using it.
Thanks,
None
0 Points
4 Posts
Re: Personal Starter Kit for MS Access
Feb 10, 2006 07:59 AM|johnsi|LINK
When I try to open the vsi file I get an error that the file is corrupted.
I'm using VS2005 Basic Edition (V8.0.50727) and have C# language installed.
I have the Personal Web Site running with SQLExpress on my host but would like to use MS Access since I'm more familiar with it. Also, managing SQLExpress databases on a remote host is damn near impossible.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Feb 10, 2006 11:07 AM|victorcorey|LINK
Hello johnsi,
Sorry about that. I was updating my website last night and somehow the files got corrupted. I have updated the files. You will need to download them again.
Thanks,
Victor
None
0 Points
30 Posts
Re: Personal Starter Kit for MS Access
May 01, 2006 11:01 PM|dalewz|LINK
Victor,
Your sharing and help are greatly appreciated.
I am new to asp.net 2.0. I need to use ms access instead of sql express as well. I downloaded your kit, which is running well.
You said "I just used the Sample Access Provider from Microsoft". May i know your steps to integrate this to your kit?
I have a site with sql express already, so it is difficult to use your template at this point. I am trying to find an easy way to use ms access for those login controls in asp.net 2.
Thanks a lot. -Dale
None
0 Points
30 Posts
Re: Personal Starter Kit for MS Access
May 02, 2006 05:05 PM|dalewz|LINK
None
0 Points
30 Posts
Re: Personal Starter Kit for MS Access
May 04, 2006 10:32 PM|dalewz|LINK
Hi,
I developed a web with ms access db for membership (my host company supports this only) based on victor's example.
So I uploaded files to the server.
Without loading dll, I got this:
Parser Error Message: Could not load type 'AccessProviders.AccessMembershipProvider'.
Host company said they may not support this provider, but I suspect they do not support asp.net 2.0 website config. They provide the following example to access DB in asp.net 2.0:
string sPath = "C:\\sites\\single??\\username\\database\\YourDB.mdb"; string strConnection = ("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + (sPath + "")); string sSQL = "Select * from tablename"; Data.OleDb.OleDbConnection objConnection = new Data.OleDb.OleDbConnection(strConnection); Data.OleDb.OleDbCommand objCommandAuction1 = new Data.OleDb.OleDbCommand(sSQL, objConnection); Data.IDataReader oDr; try { objConnection.Open(); oDr = objCommandAuction1.ExecuteReader(); while (oDr.Read) { // Write information from database here } oDr.Close(); } catch (Exception ex) { Response.Write(ex.Message); } objConnection.Close();Any suggestion? Thanks. -Dale
</div>None
0 Points
30 Posts
Re: Personal Starter Kit for MS Access
May 04, 2006 11:00 PM|dalewz|LINK
got this working by using absolute path. thanks anyway. -dale
None
0 Points
3 Posts
Re: Personal Starter Kit for MS Access
May 19, 2006 06:28 PM|BravoOsca|LINK
Thx, for a great template.
I have a small problem, when i CTRL+F5 in Visual studio everything work, and i can login with my account i have made. But when i try on the webserver where i uploaded the same code, then i can't login? I can see that it should work, because if I choose a wrong password, it says that it was wrong, but when i choose the right one, I just get an empty page.
Any thing i need to do?
Regards Bo
None
0 Points
3 Posts
Re: Personal Starter Kit for MS Access
May 27, 2006 01:30 PM|remvalenzuela|LINK
Hey all,
I'm a newbie to this ASP.NET stuff. Want to learn and have downloaded Victor's version of the starter site using VB and Access. I seem to have two issues (be gentle, I'm a newbie) BTW, both of these worked when I had the original version of the asp.net starter site.
First, after installing the site, I click CTRL - F5 and get this error:
Unknown
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: Unknown
Source Error:
Line 94: lookupCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName)); Line 95: Line 96: object lookupResult = lookupCommand.ExecuteScalar(); Line 97: if ((lookupResult != null) && (lookupResult is int)) { Line 98: return (int)lookupResult;Secondly, I cannot set up an administrator account for the site. I go to "website" -> ASP.NET Configuration -> Security and I get this error message:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store."
If I then go to "Choose Data Store" and then to "Select a single provider for all site management data" it says "no providers created" how do I create it... is it talking about an ODBC driver?
Your help to my dumb question(s) is appreciated.
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 12:17 AM|lairstream|LINK
Dude this post saved my life today...Argh! It's so hard to work with SQLExpress on a development machine...I thought it was just gonna be a plug and play kind of thing...but it was hell =)
So thanks again for posting that.
Based on my usage of it it took a little tweaking to get it to run in my SurveyCenter application (for instance I had to modify the Application name table, and clear out the old entries. Then I had to fiddle with the Configuration Manager tool site for a bit...at first it didn't work but after a few restarts it worked...the rest was modifying web.config.
Then I uploaded and Whammo! It didn't work :)
Then I did some more surfing, and sacrificing to the gods...then finally I found out that you have to tell your host to give the database folder, and all databases in it read/write/modify permissions...
That did it...ok,
Thanks a billion...
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 12:18 AM|lairstream|LINK
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 09:40 AM|victorcorey|LINK
Hmmm...Not sure. I just uploaded the files to my host and everything worked.
Have you checked the rights for the database directory?
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 09:40 AM|victorcorey|LINK
Opps..This was a reply to Bravo
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 09:41 AM|victorcorey|LINK
Are you running this under 2.0?
None
0 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 11, 2006 09:46 PM|remvalenzuela|LINK
Victor -
Not sure what was different, but I whiped the O/S and had to install all of this on another machine and now that I try it, it all works. Not sure what was different.
Thanks for the help though.
None
0 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 16, 2006 05:27 AM|BravoOsca|LINK
Got it working, i talked to the company that host my side, and they change the rights on the server, so now everything is working.
Again, thanx for a great job on this project.
Right now im trying to make a page that i can use as contol of members and roles.
Can i use the "AccessMembershipProvider.cs" and "AccessRoleProvider.cs" for this?
I have tryed ObjectDataSource, but i get an error, so i probaly did something wrong. But i have to use the "AccessMembershipProvider.cs" or am i wrong?
Regards BravoOsca
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 16, 2006 10:46 AM|victorcorey|LINK
Yes, you should be able to use the Access Providers. There are some limitations to the providers that are referenced in the readme. See below:
All providers
-------------
None of the providers support the "commandTimeout" attribute. The providers issue OleDb commands using
the default timeout for OleDbCommand(s) which is 30 seconds.
The providers all carry out read and write operations against the $safeprojectname$ database using the security
credentials associated with the current request. Unlike the built-in providers, the sample providers do
not suspend impersonation when client impersonation is in effect. This means one of the following
identities requires Read/Write access to the App_Data directory:
1. The worker process identity if no impersonation is used.
2. The application impersonation identity if <identity impersonate="true" user="userid" password="pwd" /> is used.
3. Each client identity if <identity impersonate="true" /> is used.
Parameter validation and syntax checking of parameters is current as of ASP.NET 2.0 Beta 1. As a result
the parameter validations used in Beta 2 and RTM providers will differ slightly from the validations
enforced by the $safeprojectname$ providers.
Membership
----------
Password strength requirements are not enforced in the CreateUser and ChangePassword methods. The settings are
read from configuration, but at are not used by the provider.
Account lockouts are not implemented in the provider. The UnlockUser method has no effect, and the provider
does not count bad password or bad password answer attempts.
The $safeprojectname$ provider does not support creating a new user with an explicit UserId (i.e. providerUserKey).
The $safeprojectname$ provider does not support retrieving a user based on UserId (i.e. providerUserKey).
Role Manager
------------
No known limitations.
Profile
-------
Marking Profile properties with "serializeAs=binary" will not work in partial trust web applications. Since
the sample provider does not assert any serialization permission (it can't since the sample provider is not
inside of System.Web.dll), the demand for serialization permission will fail in High trust or lower.
Web Parts Personalization
-------------------------
No known limitations.
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 16, 2006 11:07 AM|victorcorey|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.
None
0 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 17, 2006 05:44 PM|BravoOsca|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)
None
0 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 19, 2006 12:05 AM|remvalenzuela|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:
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 " +Source File: d:\hosting\remvalenzuela\App_Code\csharp\AccessMembershipProvider.cs Line: 882
Stack Trace:
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 19, 2006 12:02 PM|victorcorey|LINK
You need to make sure the database has write access.
None
0 Points
8 Posts
Personal Starter Kit for MS Access - Update has been posted
Jun 24, 2006 08:00 PM|victor.corey|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
None
0 Points
5 Posts
Re: Personal Starter Kit for MS Access
Jul 31, 2006 01:11 PM|pacecal|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
<add name="PersonalAccessProvider" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|ASPNetDB.mdb" providerName="System.Data.OleDb"/>
please help me out
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access - Update has been posted
Aug 02, 2006 12:55 PM|serseri|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:
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:
None
0 Points
8 Posts
Re: Personal Starter Kit for MS Access - Update has been posted
Aug 23, 2006 10:23 PM|noxignis|LINK
None
0 Points
9 Posts
Re: Personal Starter Kit for MS Access
Aug 26, 2006 09:28 PM|patricksy|LINK
Hi there Victor,
I'm using your Extended kit. Just wonder how do i implement Dynamic Themes. Thanks
More Power...
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access
Sep 16, 2006 06:22 PM|banna75|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]
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Nov 18, 2006 01:15 PM|CardSleuth|LINK
Has anyone run into problems displaying images? On my local server everything runs great but on my web host only a part of the image is displayed. No errors messages just a partial picture.
Here is an example http://www.annspictures.com/Details.aspx?AlbumID=3&Page=1
Any ideas?
Thanks - Patrick
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Nov 18, 2006 06:48 PM|CardSleuth|LINK
I made a change in the handler.ashx file.
This
const int buffersize = 1024 * 16;
to this
const int buffersize = 1024 * 32;
Thanks for all the great work.
Patrick
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Nov 23, 2006 12:13 PM|serseri|LINK
my english is not good execuse me
if url is empty this is error occuring... users must add an url when adding a talkback entry.
command.ExecuteNonQuery()
Line 86: Catch ex As Exception
Line 87: Throw New Exception("Error thrown in AddTalkBackEntry)", ex.InnerException)
Line 88: Finally
Line 89: If Not (connection Is Nothing) Then connection.Close()
Member
1 Points
3 Posts
Re: Personal Starter Kit for MS Access - Update has been posted
Jan 02, 2007 04:07 PM|nickneutron|LINK
Victor
I am one of the many grateful newbies who relied on you to get started with Access in asp.net. thank you.
One question if i may.
You use ObjectDataSource in your site and i wondered why you did so rather than the (apparently) simpler AccessDataSource?
I suspect the ODS is more fundamental than the ADS but there seemed to be advantages for newbies in avoiding the connectionstring.
Info is at http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.accessdatasource.datafile.aspx but it did take some finding. when MS does not want you to use a product they certainly know how to get their own way!
Nick
Member
12 Points
14 Posts
Re: Personal Starter Kit for MS Access
Feb 26, 2007 11:28 PM|airsoftware|LINK
Victor,
I am really happy with your Extended PWS. It is simply great, especially for the new options. Now I am figuring out how to make it working on both MS Access and SQL Server. I have a little web site where I put just a few pictures and it works perfect but now my "extended" family want me to create a site for all of them (around 100 people) and I am afraid that MS Access will not be the right solution.
I tried to import the MS Access database into a new "personal" SQL Server database but it copied the views as tables and did not copy the queries. With this results, I did not even try to copy ASPNetDB. How can I change back the database engine?
(I know, it sounds crazy but it happens with a so successful product!)
Thanks a lot!
.NET 2.0 database hosting Personal web site Sql Server 2005 personal kit starter
Member
59 Points
293 Posts
Re: Personal Starter Kit for MS Access
Mar 02, 2007 08:00 PM|smcmiata|LINK
I just wanted to say thank you also. I downloaded sql express but can't get the sql application to connect. I tried various "tips" from this site and others. Then I found your thread, read all the posts, downloaded the file, unzipped it and am already adding photos and working with the administration.
It is so refreshing to find something that works "out of the box." I can't wait to personalize the site!
Cheers,
SMc[cool]
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access
May 07, 2007 12:22 PM|Jayke|LINK
Hi all,
I am really excited about this Starter Kit but I was wandering if there is someone out there who changed this "Personal Starter Kit for MS Access" To save album pictures on the filesystem instead of the Access database.
For me it seems a more simple solution and gives me the possibility to change, update pictures via FTP.
What do you think?
Kind Regards,
Jayke
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access
May 15, 2007 12:22 PM|ZenOfMark|LINK
Thanks for the Access version of this template. Being new to this Visual basic, I am having trouble posting my site. Everything seems to work fine on my computer but when I move it to the hosting provider I have had noting but trouble. For a while the front end worked but not the back. I changed the Data folder to write access and now I get nothing. The front end is not even appearing. I am now getting this message.
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load type 'AccessProviders.AccessRoleProvider'.
Source Error:
Would you have any suggestions on what could be doing this?
I have even tried removing and reinstalling everything on the hosting server to try to get the front end working again and nothing.
Thanks
Error .NET 2.0 ASP.NET Membership database Personal web site Sql Server 2005 personal
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access
Oct 20, 2007 04:08 PM|pisalsachin|LINK
Hello I have sucessfully able to install Personal Starter Kit for MS Access
I have one question
If I want to use this kit on the internet for personal use then do I require the .NET licence?
Regards,
None
0 Points
7 Posts
Re: Personal Starter Kit for MS Access
Nov 09, 2007 03:51 PM|inbaraj|LINK
hello sir I have downloade the program which u gave as link sir i dont know how to insert the image in MS access file can u guid me sir it is very urgent for me... sir.. plz reply me its realy very urgent for me..... inbarajdurai@aol.com i hope i will get a reply
reg
Inba
Member
59 Points
293 Posts
Re: Personal Starter Kit for MS Access
Nov 09, 2007 04:13 PM|smcmiata|LINK
Hi Inba,
You don't insert the image into MS Access. That's the beauty of this application. Save your images to the Upload folder. If your site is remote (you have the site hosted on someone else's server) then you will have to publish the Upload folder.
Then, go to your live website, logon so you can use the administration features. Now go to the Manage link, pick albums. Create a new album and then click the Edit button. Now you can use the contents of the Upload folder (which should show on the left side of the webpage "Bulk Upload Photos") to add to the album.
Or, you can create a new album and upload each photo one at a time via the same page under the "Add Photos" section.
Check out my site: seanmcgriff.net
Good luck!
Member
59 Points
293 Posts
Re: Personal Starter Kit for MS Access
Nov 09, 2007 04:18 PM|smcmiata|LINK
Hi Pisalsachin,
If you want to have this application go live on the internet, you will have to use a hosting service that has the .net framework available. You DO NOT have to have a license, since the .net framework is a free download. Again, the server that hosts your site will need to have it!
Good luck.
None
0 Points
7 Posts
Re: Personal Starter Kit for MS Access
Nov 14, 2007 06:30 AM|inbaraj|LINK
hi...
Thanks.. I will try it and tell my experince to u.. Can u suggest me any free web hosting.......
with reg
Inbaraj.d
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access
Dec 01, 2007 01:31 PM|jlpowers|LINK
Victor,
I just would like to thank you for making the extended version available for all to use. Since I'm just learning this has saved me countless hours.. I do have a question. I'm trying to add a table so that the site owner can log in and change the content of the Default.aspx page . I can't seem to get this to work. The only option I get when trying to add a table to the personal.mdb is for a new query not add new table. Can you please tell me what I'm doing wrong.
Member
4 Points
14 Posts
Re: Personal Starter Kit for MS Access
Apr 22, 2008 06:57 AM|Kislay|LINK
It is running on my computer.Can you please guide me how to host it on web server using access database
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Apr 22, 2008 11:30 AM|victorcorey|LINK
All you would do is upload it to you hosting site.
1. Make sure you host has the 2.0 framework
2. You may need to set permissions on the App_Data directory
Member
59 Points
293 Posts
Re: Personal Starter Kit for MS Access
Apr 22, 2008 11:45 AM|smcmiata|LINK
I have been very happy with www.hostingfest.com. It's very inexpensive for the hosting and domain name. I am not affiliated with them, just satisfied with their hosting. I found them through a link on this home page, under Featured ASP.NET web hosting.
Member
3 Points
32 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2008 09:23 AM|jjkky|LINK
Hello All,
I just published the extended personal starter kit and I must say, it's nice to see modified code out there without any serious bugs. I am somewhat new with asp.net and thought the kit would be a great way to learn more about .net. I have a question concerning the email feature. My hosted site does not have a mail server on the hosted site server. I was told I could use and ip address to get to the mail server. I've searched through the extended personal starter kit for ms access and cannot find where to modify email configurations. Can anyone tell me where the ip address to get the email feature working? Thanks, Jim
Email features
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2008 02:04 PM|victorcorey|LINK
Actually I think I missed that in the download. There should be an entry in the web.config. I put it at the end:
<system.net> <mailSettings> <smtp from="{email_address"> <network host="{ip_address}" password="{password}" userName="{username}"/> </smtp> </mailSettings> </system.net>Member
3 Points
32 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2008 03:51 PM|jjkky|LINK
Thank you so much Victor. That did it! It appears the only thing left is to incorporate the video page like your site has and modify some of the css files. I love this product and can't thank you enough.
Visit http://www.jjkiefer.com
Member
38 Points
256 Posts
Re: Personal Starter Kit for MS Access
Aug 22, 2008 09:02 AM|DKB|LINK
Hi Victor I have a question regarding the extended personal starter kit. There are two page files, one concerning the password and the other, security question can you explain what your plan was for these pages. I see that they are in the root of the site I would have though that they would have been placed in the admin folder with of course admin permissions. Unless they were there for learning purposes and expecting the user to place them there in the admin folder themself. I'm a bit confused can you please instruct me in their purpose I don't see them in the sitemap. I ask only because I am a novice user of asp.net and like to ask questions before dive in to things. Thank you for your time.
DKB
Member
5 Points
98 Posts
Re: Personal Starter Kit for MS Access
Aug 22, 2008 12:13 PM|victorcorey|LINK
I think you are talking about the RecoverPassword.aspx and ChangeSecurityQuestion.aspx pages. It has been sometime since I have looked at the codebase from the default install, so I'm not sure if these were implemented. These pages are for users to recover their password and change their security question once logged in that is why they are not in the admin folder. The RecoverPassword is linked from the homepage just below the login form and the ChangeSecurityQuestion is linked from the Profile section once logged in.
Hope this helps.
Member
38 Points
256 Posts
Re: Personal Starter Kit for MS Access
Aug 23, 2008 12:42 PM|DKB|LINK
Hi Victor I see what is happen with them now I see how they are used once a person is logged in, and thanks for your prompt logical reply.
DKB
None
0 Points
42 Posts
Re: Personal Starter Kit for MS Access
Dec 12, 2008 12:28 PM|kekewong|LINK
i saw all of the post nd most of the people works fine , but for me i facing the installation problem . When i double click the personalStarterKitMSAccess.vsi, it shows a error msg , "String cannot have zero length " ,currently i am using visual studio 2008 Professional Edition . How can i solve this problem?
THanks.
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access (using GoDaddy)
Feb 18, 2009 02:03 PM|kgraue|LINK
Much thanks to Victor as well. Great job! I can host the website just fine with GoDaddy. The issue I run into is with the connection string. The default connection string in the Extended Kit is the following:
I think on any other host this would work. On GoDaddy, however; they require you to put your Access Database in their access_db folder that is created when you setup using an Access Database. The problem here is the DataDirectory part in Source=|DataDirectory|Personal.mdb; for example. Based on the following website:
http://programming.top54u.com/post/ASP-Net-2-0-Access-Database-connection-string.aspx
the DataDirectory folder refers to the App_Data folder which is where a database would be by default but NOT with GoDaddy.
My question is simple: how do I use the Extended Kit with GoDaddy with an Access Database? Is this even possible? I think I can use this connection string if I refer to the access_db folder instead of the App_Data folder. How do I do that? Help here would be much appreciated. Thanks in advance.
Kevin
connection strings GoDaddy Personal Web Site Starter Kit GoDaddy connection strings Microsoft Access Access
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access
Feb 20, 2009 09:12 AM|vsortiz|LINK
Wow. This is awesome! Thanks so much. Had no problems. Just do an Open Web Site within VS2005, and works every time!
Was even able to modify the entire application and db to store pics on a file system instead of inside the MS Access DB, which was getting very large. I store the pic's path as a string in the DB. Works great.
Thanks so much!
Personal Starter Kit ASP.NET Web Site Administration Tool
None
0 Points
2 Posts
Re: Personal Starter Kit for MS Access (using GoDaddy)
Apr 18, 2009 10:09 PM|vsortiz|LINK
Hi kgraue,
You likely figured this out by now :)
I, too, have godaddy and use this setup. I bypass the godaddy setup of having to put the access db file in their access_db folder. I have found that the MS Access DB file doesn't have to reside in the access_db folder. I completely ignore this folder and place my Access DBs wherever I desire. I just ensure the godaddy folder that houses my Access DB file has write permissions. My godaddy access_db folder is actually empty right now :)
My personal.mdb lives in the App_Data folder as the kit suggested. I never touched the kit's default settings. I loaded the kit on my local machine, ensured it worked, then just uploaded all the files from my local machine to my godaddy website, and it just always has worked.
Were you able to change the web.config settings in the kit to accomodate the godaddy access_db folder? This would be great info to know.
Good luck!
ASP.NET Membership GoDaddy access_db ms access
None
0 Points
1 Post
Re: Personal Starter Kit for MS Access (using GoDaddy)
Sep 19, 2009 05:34 PM|acustovic|LINK
Hi,
Does anyone have the Personal Starter Kit for MS Access coded in VB.NET? Any help would be appreciated.
Thank you!
Access net vb Personal Starter Kit visual basic
Member
59 Points
293 Posts
Re: Personal Starter Kit for MS Access (using GoDaddy)
Sep 21, 2009 01:59 PM|smcmiata|LINK
Mine is currently using VB.net with access:
http://www.seanmcgriff.net
The only problems I've had so far are the permissions management. That doesn't work. I have another site in our company's intranet that uses SQL w/VB.net and everything works fine.
SMc
Member
38 Points
256 Posts
Re: Personal Starter Kit for MS Access (using GoDaddy)
Feb 16, 2010 12:02 AM|DKB|LINK
Can you share out how you got the website to work with godaddy I'm guessing you did have to change the connection string.
DKB
Member
3 Points
32 Posts
Re: Personal Starter Kit for MS Access (using GoDaddy)
Feb 22, 2010 01:15 PM|jjkky|LINK
All I did was give GoDaddy.com the IP address of my website which was being hosted by another company.
Member
3 Points
32 Posts
Re: Personal Starter Kit for MS Access
Apr 20, 2010 01:54 PM|jjkky|LINK
I've forgotten the admin password. Is there a way to reset it somehow?