Click here to Skip to main content
14,218,851 members

ASP Guestbook Application

Rate this:
4.33 (8 votes)
Please Sign up or sign in to vote.
4.33 (8 votes)
17 Oct 2000CPOL
A simple guestbook application using ASP and an Access database
  • Download source files - 15 Kb


    This is a small ASP (Microsoft Active Server Pages) application that implements a guestbook.

    The guestbook has the following main-functionality:

    • Display entries with author-name, e-mail, date and text
    • Administration mode: delete entries
    • Navigation: jump to first page, last page, previous page, next page, discrete pages

    The sample is ready-to-use. As-few-as-possible HTML-formating (e.g. fonts) is done in order to keep it clear. You could modify the following things:

    • Change the language of the texts
    • Adjust the design to your needs
    • Extend the functionality (please e-mail me, if you improved it, since I'm very interested in any improvements)


    The guestbook stores its entries in a Microsoft Access 2000 database (Access 97 works quite well, too - just convert the database) and accesses the database using ADO (Microsoft ActiveX Data Objects, see To use the Access 2000 database, you probably need the latest version of the Microsoft Data Access Components (MDAC, also from

    I tried to comment the ASP code as well as I can. When you look through it with a syntax-coloring editor, you should find the comments quite easily. I also tryied to minimize the allways-present problem of having code mixed with design/content be separating ASP from HTML as much as I can. Still I wanted to keep all things in one file to make it compact. So the ASP pages became a bit longer than it normally would.

    I'm running this guestbook under a german version of NT 4.0 server, service pack 6a (the 'a' is very important). Altough, SP 4 or 5 should be no problem, too.

    A last tip for editing ASP files: I tried a lot of editors (including Frontpage, InterDev, etc.), I found the most usable program is EditPlus, which you can find on

    Please feel free to ask any questions you have by e-mail:


    18 Oct 2000 - updated script.

  • License

    This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


    About the Author

    Uwe Keim
    Chief Technology Officer Zeta Producer Desktop CMS
    Germany Germany
    Uwe does programming since 1989 with experiences in Assembler, C++, MFC and lots of web- and database stuff and now uses ASP.NET and C# extensively, too. He has also teached programming to students at the local university.

    In his free time, he does climbing, running and mountain biking. Recently he became a father of a cute boy.

    Some cool, free software from us:

    Deutschsprachiges Forum zu Elektromobilität und Tesla  
    Windows 10 Ereignisanzeige  
    German Developer Community  
    Free Test Management Software - Intuitive, competitive, Test Plans. Download now!  
    Homepage erstellen - Intuitive, very easy to use. Download now!  
    Send large Files online for free by Email

    Comments and Discussions

    GeneralError: Can not insert record into database Pin
    sharp_k11-Mar-09 6:42
    membersharp_k11-Mar-09 6:42 
    I tried to make the guestbook by creating my own Access Database at the server but that did not apparently work well. Well an easy approach is to upload the database and the index.asp both. In this case it did work but I get the following error when i insert a guest book entry

    Microsoft JET Database Engine error '80040e09'<br />
    <br />
    Cannot update. Database or object is read-only.<br />
    <br />
    /database.asp, line 206 

    I have verified the file itself is not read only. I am not supplying any password to the website. I am not sure why I am getting this message. Any help will be appreciated. Thanks
    GeneralRe: Error: Can not insert record into database Pin
    Nancy B20-Oct-09 4:47
    memberNancy B20-Oct-09 4:47 
    Generalscreenshot Pin
    sharp_k8-Mar-09 17:44
    membersharp_k8-Mar-09 17:44 
    GeneralMedicine for you Pin
    Kedaar12-Oct-08 11:01
    memberKedaar12-Oct-08 11:01 
    GeneralProbably it for you Pin
    Kedaar17-Apr-09 6:27
    memberKedaar17-Apr-09 6:27 
    GeneralHi!! Pin
    Coder_200729-Oct-06 18:30
    memberCoder_200729-Oct-06 18:30 
    Generaltest for subject Pin
    Anonymous16-Feb-04 15:30
    memberAnonymous16-Feb-04 15:30 
    GeneralRe: test for subject Pin
    Anonymous31-Jul-04 5:34
    memberAnonymous31-Jul-04 5:34 
    GeneralRe: test for subject Pin
    Anonymous9-Dec-04 21:17
    memberAnonymous9-Dec-04 21:17 
    Generalneed for a help Pin
    reymar1-Aug-03 18:05
    memberreymar1-Aug-03 18:05 
    GeneralRe: need for a help Pin
    David Jhon17-Aug-06 17:31
    memberDavid Jhon17-Aug-06 17:31 
    Generalerr Pin
    Anonymous27-Jul-03 5:01
    memberAnonymous27-Jul-03 5:01 
    GeneralSource Code Pin
    littleblack22-Jun-03 23:02
    memberlittleblack22-Jun-03 23:02 
    GeneralRe: Source Code Pin
    Nino_123-Jun-03 4:37
    memberNino_123-Jun-03 4:37 
    GeneralDatabase access Pin
    Ineffable7-May-03 14:07
    memberIneffable7-May-03 14:07 
    GeneralRe: Database access Pin
    Uwe Keim7-May-03 19:28
    sitebuilderUwe Keim7-May-03 19:28 
    Generaltask 1 Pin
    Anonymous3-May-03 7:35
    memberAnonymous3-May-03 7:35 
    GeneralRe: task 1 Pin
    Anonymous3-May-03 7:36
    memberAnonymous3-May-03 7:36 
    Generalmerhaba Pin
    Anonymous2-May-03 13:11
    memberAnonymous2-May-03 13:11 
    General&#3604;&#3604;&#3604;&#3604;&#3604; Pin
    Anonymousด26-Apr-03 21:52
    sussAnonymousด26-Apr-03 21:52 
    Generaltest Pin
    Anonymous4-Apr-03 1:46
    memberAnonymous4-Apr-03 1:46 
    GeneralRe: test Pin
    Anonymous3-Mar-05 16:38
    memberAnonymous3-Mar-05 16:38 
    GeneralHello Pin
    Zioner20-Feb-03 22:14
    memberZioner20-Feb-03 22:14 
    Generalhello Pin
    Anonymous9-Feb-03 22:01
    memberAnonymous9-Feb-03 22:01 
    GeneralRe: hello Pin
    Anonymous23-Feb-05 23:07
    memberAnonymous23-Feb-05 23:07 

    General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

    Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

    Posted 20 Jan 2000


    44 bookmarked