Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    8

    Lightbulb Unanswered: Access on the WEB!!

    I need advice on how to put/convert an Access Database onto the Web.

    I have an Access database of around 400,000 records which needs to be made available on the web. I understand that Access is not the best package at allowing multiple users especially when the database becomes this large, but that is all i know!

    What i'd like is information on how to put databases on the web, right from the start! so things like what package to use, how easy/hard it is to change access into another format, how long it takes, how it sits on your website, how to manage it etc etc.

    Basically, any ideas on this topic would be welcomed!

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Access can deploy forms on the web as Data Access Pages - but each viewer needs a licensecd copy of a micrpspft DLL - it works ok on intranets.

    The basic data storgae method that Access uses is Jet which some proponents claim has real problems used as a web data store - I have my doubts on that claim, unless you are expecting a massive number of concurrent database requests on your site, providingt hat the datastore is on the same physical server as the webersver.

    If you are intending developing a web site then you have various options, one route is to use the microsoft ASP / ASP.NET scritping language, another is to use PHP, a third route is to use soemthing like Macromedia Coldfusion.

    None of these is particularly quick.

    Depending on the volume of traffic and budget you need to select the data store (as server based datastore would be best) the method of generating the web page.

    Most of the work I've been involved in recently is written PHP using MySQL as the backend. The reason, usually my customers are even more of cheapskate than me so budget is always an issue. For career purposes I'd got ASP/ASP.NET and Microsoft SQL server.

    I have seen numerous helpfull books on wrriting PHP & MySQL books.

    However it depends primarily on how good your basic design is, and somewhat on your programming skills.

    There is totally different design style between web & other systems. its not especially steep learning curve, espescailly with guidance from good books.


    HTH

  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
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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