Results 1 to 14 of 14
  1. #1
    Join Date
    Mar 2007
    Posts
    4

    Unanswered: Access database to a web page?

    I'm pretty new at access. I just started reading a book on it and plan to become at least somewhat proficient and knowledgeable after it. But i was just wondering if it is possible to put an access database online. For example, what I wanna do is this:

    I'm in a house with about 60 other guys and I want to make a profile section on our webpage that will let visitors know who's in the house, what their major is, maybe a picture, hobbies etc. I was gonna store this information in an access database. I was wondering if there is anyway to transfer this database's content onto a webpage in a layout that I design. I heard asp was the way to go for this but do not know how to go about it. Any help would be good! Thanks!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I would definately suggest ASP using VBScript - simply because VBA and VBScript are not 100 miles a part.

    Now I know I'll get htis next bit wrong and somoene will correct me - but an Access database to an ASP page will use an ADO connection : I suggesat you take a peek at these in your book.
    Infact, take a look at ADO and DAO and ODBC connections (simply to cover my own answer )
    George
    Home | Blog

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I'd agree with the ASP suggestion, though my experience is with Windows servers. I believe the rule of thumb is ASP for Windows servers, PHP for Linux servers (but don't quote me on that).

    I have heard from a reliable source that FrontPage has a wizard that will walk you through the connection to the database and write most of the ASP for you. Haven't tried it myself though.
    Paul

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If you want my advise - NEVER even open FrontPage...
    George
    Home | Blog

  5. #5
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    I'm with GeorgeV all the way on NEVER even open frontpage! DreamWeaver is the software of choice. It will walk you through the connection to the database and write most of hte ASP for you, but it does not leave a 1000 extra, unnessary lines of code in your web page like FrontPage does.
    And Paul was right about ASP, you will need a Windows server. Who ever you are look at to host your web page, they will need to support ASP.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I feel the same about dreamweaver too...

    If I had to chose, dreamweaver would ALWAYS win, without a shadow of a doubt.
    George
    Home | Blog

  7. #7
    Join Date
    Sep 2006
    Posts
    265
    I have a web site supporting over 12,000 images running on top of an Access 97 database. Yes it is possible and yes it works. You will need to find someway of defining the aspect of the images and these can be collected by your database and used thus:

    <img src="<%=Session("Link")%>/<%=rs("FileName")%>" width="<%=rs("ImageWidth")%>" height="<%=rs("ImageHeight")%>">

    Best connection method I've found is OLE, in fact the only use for OLE.

    global.asa

    Application("my_conn") = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\Inetpub\wwwroot\....

    ASP Page

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.ConnectionString = Application("my_conn")
    conn.open

    Whatever method you use to create your pages the key is understanding your code, what it does and why.

  8. #8
    Join Date
    Mar 2007
    Posts
    4
    this is some pretty helpful stuff, thanks.

    I just tried the exporting a database to html feature and it just puts it exactly like it looks in access itself in a very simple table. What i need to do is make a layout for each database entry (like the name at the top, split the middle row into two columns, one with a picture, one with some more information etc. etc.) to make it look nice and professional and then have a space between each entry. Or maybe even a separate page for each entry. Can this be done?

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    In theory, if you can produce what you want in a report in access then the same can be done in asp.

    I suggest you check out the w3schools ASP tutorials!
    George
    Home | Blog

  10. #10
    Join Date
    Sep 2006
    Posts
    265
    It should be simple but its not that easy. You need to:

    1) Get the data onto the page
    2) Create a style sheet css file for the presentation features
    3) Then after the Header information get into the actual information to be displayed. This is just a shell:

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <HTML><HEAD><title>Description</title>
    <meta name="description" content="Description">
    <meta name="keywords" content="keywords">
    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
    <link rel="stylesheet" href="http://Domain Name/include/style.css"></HEAD>

    <BODY><Table class="TableLeft" align="left" width="84%" border="0" cellpadding="0" cellspacing="0"><tr>
    <td width="28%" height="50%" align="center" valign="top">
    <span class="ccsName"><B>Description</B><BR><B>blah blah</B></a><BR>
    <img src="http://DomainName/Directory/Image.jpg" width="nnn" height="nnn" vspace="nnn" border="0" alt="Whatever></a><BR>
    <span class="cssanothername"><B>blah blah</B><BR>
    <I><B>blah blah</B></I></span></td>
    <td width="28%" height="50%" align="center" valign="top">
    <span class="cssname"><B>blah blah</B><BR><B>blah blah</B></a><BR>
    <img src="http://DomainName/Directory/Image.jpg" width="nnn" height="nnn" vspace="nnn" border="0" alt="Whatever></a><BR>
    <span class="cssanothername"><B>blah blah</B><BR>
    <I><B>blah blah</B></I></span></td></tr></table></BODY>

  11. #11
    Join Date
    Mar 2007
    Posts
    4
    I just read the chapter on reports and messing with the design of reports. I think I have my solution there. Just kinda make it the way I want it and export it to html. This is a very caveman strategy but for the knowledge that i got, i'm not doing too bad

    Now the next question is,

    I'm tryin to make a member profile section for my fraternity. There's about 60 guys in the house and I want the page to say their name, year in school, major, hobbies, a picture etc. Is there anyway I can make a form that they can fill out (without having to use access) that will populate a database automatically so I make a report with it. I could always just collect their information by hand and input it myself but I'd like to save the time. I'm thinking I need to do something online for this with a server, please offer some guidance!!

  12. #12
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Well you'll need a database to store the data but sure, you can create an online form which they can submit.

    A simple form... (you may want to change the GET method to a POST)...
    Code:
    <form method="get" action="simpleform.asp">
    First Name: <input type="text" name="fname" />
    <br />
    Last Name: <input type="text" name="lname" />
    <br /><br />
    <input type="submit" value="Submit" />
    </form>
    Oh and remember to use the xhtml closing />'s (let good coding practice start here!)
    George
    Home | Blog

  13. #13
    Join Date
    Mar 2007
    Posts
    4
    hmm a form seems easy enough to make. Now the question is how do i make that form send information to a database?

  14. #14
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    The answer: ADO Connections with SQL!
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •