Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2005
    Location
    Adelaide
    Posts
    6

    Question Unanswered: MS Access and the Web

    I am reasonably competent in single-use and LAN-use Access but now need to develop an application which will require data entry and data access remotely over the web. The development will take place at a site that requires the bulk of the system's use and there are two remote sites/users requiring access.

    I think that I can integrate what I need using Front Page and Access using XML, but as a newbie to web-development I would appreciate being pointed in the right direction. Quite possibly several directions!..

    Thanks in advance.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Several directions you say?

    php, asp, java....
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps this may hopefully give you some ideas:

    Web Database Concept
    http://www.bullschmidt.com/concept.asp

    This is something I put together about ASP that hopefully might help somehow.

    You and others can have access to a database hosted on the Web from any location that has a browser with an Internet connection.

    The Web database concept makes sense if you and your people want to do work in various locations in or outside the office and still be "plugged" in.

    For example you could have employees enter timesheets or have sales reps log their contacts. Or perhaps you'd like customers to be able to check the status of their orders online without having to call the company.

    If you want a Web database, typically what would happen is that a database such as Access (basically just consisting of tables) would be put on the Web.

    Then "dynamic" Web pages (such as classic ASP pages which include VBScript, HTML, and/or JavaScript) would be created acting like the old desktop database's queries, forms, and reports to access the database - all hosted on a Web Server.

    Dynamic Web pages are similar in many ways to regular HTML pages. But they are "live" because the user can read from and write to information in the database. An example where you can login and add, edit, or view fictional customers and invoices is at http://www.bullschmidt.com/login.asp

    Not all Web hosts will handle dynamic Web pages but many do. The Web hosts that can handle ASP pages usually have a Windows 2000 or Windows 2003 operating system running an IIS Web server.

    Here are a few good ASP sites:
    o ASP101 Samples - http://www.asp101.com/samples
    o W3Schools ASP Tutorial - http://www.w3schools.com/asp
    o Microsoft VBScript Language Reference - http://msdn.microsoft.com/scripting/...bscripttoc.htm

    And the following newsgroup is good:
    microsoft.public.inetserver.asp.general
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  4. #4
    Join Date
    Jun 2005
    Location
    Adelaide
    Posts
    6
    I am sorry to take so long to reply. Thanks for the prompt comment.

    My environment is ADO 2.7, Access 2003 with no SQL at present. I would consider using MySQL if either security or performance were enhanced significantly.

    I am going to take a look at asp in the first instance via the websites suggested by Paul Schmidt.

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by johnwilliamson
    My environment is ADO 2.7, Access 2003 with no SQL at present. I would consider using MySQL if either security or performance were enhanced significantly.
    MySQL is a good deal better in both areas when compared to Access...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by johnwilliamson
    ....I would consider using MySQL if either security or performance were enhanced significantly....
    Just curious, in which areas do you think MySQL lacks in terms of either security or performance, I have no real axe to grind favouring one product over another but I have not picked up any substantive differeneces in both those areas in MySQL compared to other PC based SQL servers.

    I do miss the concept of groups or roles in MySQL security which makes a adding a new user potentially a pain and exposes you to incorrect assignment of permissions, but the security model seems pretty competant from what I've seen so far. Perfomance - depends on what you are doing, again it seems pretty comparable (usually better) compared to others.

    Maybe Frontpage has grown up and become much better behaved, but when I last looked at it (the time of Microsofts dreadfull Intranet tool) it looked pretty rough and did a lot of very dirty and uneccesarily propriatory tricks. Maybe its moved on, I hope so...
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Jun 2005
    Location
    Adelaide
    Posts
    6
    I have not used MySQL and have only an impression from earlier readings that it is not as secure as proprietary DBs, but what I have read in the past month suggests it is both fast and robust, so I'll look no further for an external DB.

    Front Page is just first cab on the rank at this time. There are now so many options. I think Microsoft have relinquished a little (just a little) of the idea that they own the world's computing resources and standards, making a later version of FP a better option than it was.

    Thanks

Posting Permissions

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