1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Newbie question

Discussion in 'MS Access' started by jazzlall, Oct 18, 2006.

  1. jazzlall

    jazzlall New Member

    Quite new the world of access - I know the basics pretty much. What I wanted to know, and I am sorry if this sounds like a really stupid question, but hoping someone will be able to give me some advice.

    I am looking to design a database in access which is fully accessible on the internet also on a webpage. What would need to be done to achieve, a few people I have spoken to have mentioned ASP.net & ADO.net.

    Is it just a matter of creating the entire database locally and then using some code to upload it on the internet, making sure my host supports asp etc?

    Thanks in advance
  2. shabbir

    shabbir Administrator Staff Member

    The persons whom you have asked have told you the perfect solution and to have anything on web you need web languages and the best language is ASP / ASP.net

  3. jazzlall

    jazzlall New Member

    Thanks for your response, much appreciated :)
  4. shabbir

    shabbir Administrator Staff Member

    My pleasure.
  5. jazzlall

    jazzlall New Member

    I have pretty much completed the access project, which includes tables, forms , reports, queries etc. It also have a front end on for easy navigation for my uncle (it's for him)

    Just slightly confused about putting it on the internet now. What would you recommend would be the best way to do this, obviously using ASP is the solution, but what application shall I use. Could it be done in frontpage with aspx files which would trigger the .mdb to be opened through the webpage? Or isn't it as easy as that.

    Thanks in advance
  6. ever_thus

    ever_thus New Member

    aspx pages allow you use code behind pages written in VB or C#. In the aspx page (which is mostly like a normal html page), you would lay out the controls that get things like the query fields and passwords from the user. Each control is associated with an event handler, which means that when you do something to the control, a method with says handles <event> is called. In that event handler you do what you want.

    The event handlers are, as I said written in VB or C#. Both provide methods for opening databases (Access or otherwise), making queries, and suchlike. For instance to open a database you code Connection.open () (where Connection is a Connection object representing your database). Most of this is done with calling the appropriate methods on .NET database objects.

    When you've got something to send back to the user, you give it a name that appears in your aspx page, and/or invoke an event that will display it. In the aspx you use names defined in the code behind in tha format <%name%>.

    That's it in short. To get the details like sytax and supported objects look at W3C's ASP.NET tutorial, MSDN's ASP reference and MSDN's VB reference

Share This Page