Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access and the Internet

Discussion in 'Information Technology' started by Bob Wardlow, Jul 28, 2006.

  1. Bob Wardlow

    Bob Wardlow
    Expand Collapse
    Guest

    I have developed several Access applications over the years for clients. I
    have also developed many websites for my clients. But I have never put the
    two together. Can anyone answer a couple of questions for me?

    I see the ability to create data access pages in Access. Is that the way to
    link an access atabase to a website?

    If I use Access with a website, can I use all the tools inside Access the
    way I do with a non internet application or am I limited?

    Is there a Microsoft resource or a book that specifically deals with
    creating or customizing Access applications to work on the internet?

    I fully expect that I may have been keeping my head in the sand all these
    years and these are dumb questions but it would be very helpful for me to
    know the answers.

    Thank you in advance for your time and help.

    Bob Wardlow
     
  2. Loading...


  3. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    Bob:

    I haven't found DAPs to be that useful, though I understand they can be, so
    long as they're used on an inTRAnet and not the InTERnet.

    Classic ASP is simple and works well for some things. A couple weeks ago I
    created an ASP page which I'll use for an upcoming article at Database Journal.
    It reads the MSysObjects table to display a list of tables. Select a table and
    it paints the records on the screen. The link below shows you the code for it.

    http://amazecreations.com/showmethetable/ShowMeTheTable.asp

    If you want to update a record, it will take more work, but I've got another article
    at the DBJ site that shows how you would do that.

    http://www.databasejournal.com/features/msaccess/article.php/3487741

    Some feel that Access is neither robust nor secure enough to use for the data
    store of a web app. There's some merit in that argument, unless you want to
    display and/or edit a small amount of data by a small number of users. It's not
    a perfect solution, but it's inexpensive and relatively quick to build.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "Bob Wardlow" <BobWardlow@discussions.microsoft.com> wrote ...
    >I have developed several Access applications over the years for clients. I
    > have also developed many websites for my clients. But I have never put the
    > two together. Can anyone answer a couple of questions for me?
    >
    > I see the ability to create data access pages in Access. Is that the way to
    > link an access atabase to a website?
    >
    > If I use Access with a website, can I use all the tools inside Access the
    > way I do with a non internet application or am I limited?
    >
    > Is there a Microsoft resource or a book that specifically deals with
    > creating or customizing Access applications to work on the internet?
    >
    > I fully expect that I may have been keeping my head in the sand all these
    > years and these are dumb questions but it would be very helpful for me to
    > know the answers.
    >
    > Thank you in advance for your time and help.
    >
    > Bob Wardlow
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

Share This Page