This piece of code demonstrate the way of accessing database (basic reading and writing).
Good for beginners who wish to learn ASP.
Nearly every line is documented.
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:
Re-scan downloaded files using your personal virus checker before using it.
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...
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.
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.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Wow, this is what I need!!! Great code for begenners and a great comment/line ratio!!! Keep up the good work!!! (If this comment was disrespectful, please report it.)
I think this is a great code. I can view the inputed data fine. Except when i want to open the data base, since i am using access 97, how do i update this so i can view the imputed data through access. any help will be appreciated.
thanks. (If this comment was disrespectful, please report it.)
Thank you very much... This really help me understant how ASP works. All the tutorialls on the net are so advanced that i could never understand them..This is a perfect tutorial for beginners.. Thanks a lot Arsalan (If this comment was disrespectful, please report it.)
I just want to say how much we apretiate the submitions ppl make, cause I think thats not said enough (If this comment was disrespectful, please report it.)
I want to thank you for this code. It is well documented and helps newbies out when trying to use ASP and apply it. (If this comment was disrespectful, please report it.)
Great code been looking for a simple code like this for ages thanks for makeing this available and a top notch! Explanation on wot everything does :) icq 6051839
(If this comment was disrespectful, please report it.)
Stewart MacFarlane : Its because the folder in which you've kept the database file doesnt have read/write permission, that is why its giving the error (If this comment was disrespectful, please report it.)
Thank you so much for posting this! In dealing with many database connection errors, i put this on my server and with a few changes to match my locations of files, it worked! You and your clean, easy code saved the day. I thank you!!!! (If this comment was disrespectful, please report it.)
Thanks for sharing your great ideas and ASP inventions with the masses. I'm sure that my limited knowledge of ASP will improve after studying your code.
Also, do you know of any downloads on this site that can be used to create something like a a review site for autos, with a reviews page and payment page for advertising and stuff?
Thanks, Chris Woods chriswoods@ntlworld.com (If this comment was disrespectful, please report it.)
10/1/2002 9:07:47 PM:
The code doesn't work on my website. What possible reasons might there be? I keep getting 500 errors every time I try to run the command. (If this comment was disrespectful, please report it.)
See above for the solutions to your problem. (If this comment was disrespectful, please report it.)
2/20/2003 12:26:39 AM:
hi there, i also got problem same as macfarlane. what do you mean by because of the database file doesn't have read/write permission, the page got the error. how do we know it is on permission or not. i check my folder (in which the database reside), and it is not read-only. hope u can help me. (If this comment was disrespectful, please report it.)
Read/Write permission of the folder have to be set from the server software (Personal Web Server or IIS). (If this comment was disrespectful, please report it.)
I have been searching the internet for a "Linking System" I have been needed to have a "Database Driven Links Page" on this site that I am developing. And never could find one that was good easy to understand, But looking through your code, I was able to learn in "5-minutes" how to connect onto "2" Tables and make the information work together. Thus creating a Web link, With "Link Name - From Table Name" & "Link URL - From Table URL" Man this is sweet, thank you so very much for taking the special time to write this code tutorial for us, This is surpurb, Please keep up the great work.
Wayne & Carr Barron Carrz-Fox-Fire Promotions (If this comment was disrespectful, please report it.)
p.s. Just voted for you to bring you up to [28-votes].......
And I just have to say this much now. This code is so very well documented and easy to follow and has been viewed [45490 - times] I do no see why only [28 - people] have voted for this code.
Great Work [Code Master]
Wayne & Carr Barron Carrz-Fox-Fire Promotions (If this comment was disrespectful, please report it.)
(If this comment was disrespectful, please report it.)
2/25/2004 4:54:08 PM:
hey thanks for the code its great! but i have one problem... for some reason it doesnt allow me to add more fields accept for the name field...
thanks for your time... - ben (benovak@walla.co.il) (If this comment was disrespectful, please report it.)
3/10/2004 1:15:31 AM:
nice code. tnx a lot! ü (If this comment was disrespectful, please report it.)
4/12/2004 2:01:50 AM:
It's really nice code! thanks! (If this comment was disrespectful, please report it.)
4/14/2004 11:05:07 AM:
Other errors? I am getting the same error about the DB not being able to add or delete. I have set the permissions to every possible combination in IIS and in Windows. I can't get it to work no matter what. Any suggestions? (If this comment was disrespectful, please report it.)
8/26/2004 7:47:50 AM:
Did you via explorer, right-click on the catalogue where the database is at, select Properties, Web Sharing, and select Share this folder ? Make sure it has Read/Write access (If this comment was disrespectful, please report it.)
8/26/2004 7:59:28 AM:
If you want to know how to add more fields then just "name", email me and ill give you the code and explain. It's really simple but it can be hard to understand if you're really new. I can't explain it here since the site doesn't allow script code/html posting in this comments section.
My email: keyzersoze@swipnet.se (If this comment was disrespectful, please report it.)
8/26/2004 8:00:27 AM:
I mean it can be hard to understand how to add more fields from the original code (If this comment was disrespectful, please report it.)
good source code please put a flash simple (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.)
By 32 Users
Download code
9/7/2000 1:25:43 PM: 
