Login
Important alert: (current site time 7/15/2013 10:34:13 PM EDT)
 

winzip icon

A starter project in ASP and ACCESS

 Email
Submitted on: 7/6/2006 10:52:25 AM
By: Kevin Philips 
Level: Intermediate
User Rating: By 11 Users
Compatibility: ASP (Active Server Pages), HTML, VbScript (browser/client side)
Views: 27287
(About the author)
 
     **UPDATED** A starter project for new people to ASP and Access Databases, this script shows efficient INSERT, UPDATE, DELETE statements with CSS styling and a custom built paging script. Please vote - any feedback welcome.

 
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
'**************************************
' for :A starter project in ASP and ACCESS
'**************************************
You can use any of the code or the styles in any project for whatever reason, you don't have to provide a link but credit is always nice to have.
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
  2. You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 1 submission(s) by this author

 
Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:
Your Vote

What do you think of this code (in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)
 
Other User Comments
11/30/2006 12:40:55 AM: Ginu

Hi,Friend this code is very simple and also very effictive with stylesheet.Very helpful for me Thanks
by
ginu.awardspace.com
(If this comment was disrespectful, please report it.)
 
1/4/2007 2:25:31 AM: 

It has been a great help, thanks a lot!!
(If this comment was disrespectful, please report it.)
 
1/15/2007 8:21:54 AM: Yonas

It a nice program
(If this comment was disrespectful, please report it.)
 
2/1/2007 9:55:15 PM: jojo

Hi,this program is very understand coz step by step the procedure. Thanks and more power to you..
(If this comment was disrespectful, please report it.)
 
2/3/2007 8:59:48 AM: Kevin Philips

Geez, thanks guys for the comments, I really appreciate you taking the time to provide feedback. I am developing this application to include other features and please check back every now and then to get a new version, as always all code is free to use in any way and I'm not bothered if you don't add me in the code.

The next project coding is a product information management tool.
(If this comment was disrespectful, please report it.)
 
2/4/2007 12:27:23 PM: baka

Hello, first off very nice code and design,I put it in the initpub/wwwroot directory and opened it in localhost and got to view the display but if i try to update,add or delit i get a error page ,sori i just very new to all this ,any help will be greatly appreciated
and thanks again 4 the great code
(If this comment was disrespectful, please report it.)
 
2/5/2007 12:51:32 PM: Kevin Philips

Hi, can you tell me more about the error you are getting, I am happy to help, I would bet the database permissions are incorrect.
(If this comment was disrespectful, please report it.)
 
2/6/2007 4:32:33 AM: baka

Thank,i'm very new.I can see the data in the display.asp but if i try u add,delit or update i gives error
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/starter/InsertReg.asp, line 16

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
POST 96 bytes to /starter/InsertReg.asp

POST Data:
txtName=asd&txtTyp1=PLAYER&txtDepartment=asd&txtNumber=2341&txtEmail=asdas@asd. com&Submit=Submit
(If this comment was disrespectful, please report it.)
 
2/9/2007 7:52:56 AM: baka

Nvm thanks got it working but if i add any new droplist in update it cant update i even changed the updatereg but maybe wrong
any way thanks
(If this comment was disrespectful, please report it.)
 
2/11/2007 8:28:09 PM: baka

thank for the info i got all of it to work but i still cant add any thing in the update form.the add and display form i add a few new dta collems.BUt cant get it to link ,i tryed to change the update reg and editperson but cant.But thanks alot 4 the code it very great.
(If this comment was disrespectful, please report it.)
 
4/18/2007 4:55:27 AM: ctlo

This program is easy understand. I have the same experience with 'baka'. This program runs excellant in Windows2K, you can add, delete and edit everything on the fly. But when I tested on Windows XP Prfofessional, I could only view the data. The error messages as 'baka' said in his post on 2/6/2007. Are there any workaround Ken?
Thanks!
(If this comment was disrespectful, please report it.)
 
4/18/2007 11:03:01 AM: Kevin Philips

Hi,

Thanks again for the feedback and please keep it coming...

If your comments specifically relate to the entries on the 6th February then they are likely to be permission related, I am running this on XP Pro so it can't be OS specific.

You need to allow the IUSER_yourmachinename read and write access to the database or the higher level folder in which it resides. To do this you should be able to right click on the file/folder > select properties > select security and add the account above to the list, then you need to give modify or read/write permissions. If you don't have the security tab as visible it is likely that you have simple file sharing setup and need to change this within folder options. Please get back to me if you are experiencing any further issues.
(If this comment was disrespectful, please report it.)
 
4/20/2007 1:51:22 AM: ctlo

Thank you so much for your comments. It works pretty well now. However, when editing records containing an apostrophe, it bails out. Please offer your comments. I am so sorry to bother again.
(If this comment was disrespectful, please report it.)
 
4/20/2007 12:14:22 PM: Kevin Philips

Hi, its no problem you guys asking questions and the apostrophe is a common issue to have to deal with in programming as it acts generally as an escape character for strings. Within the insert or update scripts you could run a small validation check that either wraps the apostophe in quotes or replaces the apostrophe altogether with the encoding value. I am not in a plce right now where I can get to the script but when I do I will update the pages to deal with this specific issue amongst some others which have since been identified. Please keep an eye on this post to see the update...

Best Regards

Kevin
(If this comment was disrespectful, please report it.)
 
8/24/2007 11:31:41 AM: Steve

I get such error When doing edit.
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/smic/site-admin/editperson.asp, line 8


Can pls help on this
(If this comment was disrespectful, please report it.)
 
8/24/2007 11:36:37 AM: Steve

Hi i am having problem with the edit mode
Error :
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/smic/site-admin/edit.asp, line 8

Here the code
<%
Dim SQLGetPeople, rsPeople
SET rsPeople = Server.CreateObject("ADODB.RecordSet")
SQLGetPeople = "SELECT * FROM tblstudent WHERE student_no = "& Request.QueryString("Rec")
rsPeople.open SQLGetPeople,conn,3,3
%>


Can you pls help me
(If this comment was disrespectful, please report it.)
 
5/23/2008 6:00:30 AM: zedekiah

hi kelvin your code work perfect but when trying to use your code in my database i got the following error Error Type:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
/db/InsertReg.asp, line 14, column 366
SQLInsertNew = "INSERT INTO Person (FamilyName, GivenName, EmailAddress, Password, StreetAddress1, StreetAddress2, City, State, Postalcode, country) VALUES ('" & Request.Form("txtFamilyName") & "', '" & Request.Form("txtGivenName") & "', '" & Request.Form("txtEmailAddress") & "','" & Request.Form("txtPassword") & "','" & Request.Form("txtStreetAddress1") & "','" &

can you help me this problem?
(If this comment was disrespectful, please report it.)
 
10/10/2008 2:28:06 PM: Shibboleth

Thanks Kevin has helped me alot making a start with aspVBsrcipt also thanks for the permission issue advice allround Great
(If this comment was disrespectful, please report it.)
 
10/11/2008 7:40:44 AM: shivakumar

Good
(If this comment was disrespectful, please report it.)
 
1/28/2009 3:02:16 AM: liana

hi kelvin..
i got prob when i want to update..

# Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/UpdateReg.asp, line 45

# Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5

# Page:
POST 105 bytes to /UpdateReg.asp

# POST Data:
txtName=Janet+Do&txtTyp1=PLAYER&txtDepartment=PLD&txtNumber=2674&txtEmail=jd1%4 0company.com&Submit=Update

i also got prob when i want to submit..
# Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/InsertReg.asp, line 16

# Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5

# Page:
POST 90 bytes to /InsertReg.asp

# POST Data:
txtName=liana&txtTyp1=PLAYER&txtDepartment=msia&txtNumber=2000344&txtEmail=-&Su bmit=Submit

PLEASE HELP ME ABOUT THIS PROBS...
(If this comment was disrespectful, please report it.)
 
11/26/2009 3:19:03 AM: Hi

hi kevien
application is good
but add/Edit/del not working
when i add any thing it shows page cannot be displayed

please respond
(If this comment was disrespectful, please report it.)
 
7/18/2011 12:31:45 PM: hamid

its great and helpful coding for me thank u
(If this comment was disrespectful, please report it.)
 
Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
 

To post feedback, first please login.

Search:

Newest postings for ASP/ VbScript.

Add this ticker to my site

Daily code email

Click here to join the 'Code of the Day' mailing list!

This site on CD

Over 7,000 submissions on a super fast CD!

Code/Articles

Top Code

Community

Jobs

Other

Goto…

Copyright© 1997-2013 by Exhedra Solutions, Inc. All Rights Reserved.
By using this site you agree to its Terms and Conditions. Planet Source Code™ and the phrase "Dream It. Code It"™ are trademarks of Exhedra Solutions, Inc.