Welcome to SPN

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

Sign Up Now!

Access Database on WEb Server

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

  1. TerryTech

    TerryTech
    Expand Collapse
    Guest

    I have a couple of websites where I use Access Databases to manage data that
    is dynamically controlled by 1.Coldfusion Applications and 2. ASP forms.
    Since setting these applications up, and having them in use without any
    problems I have come across advise that Access is not stable as a Web based
    database.
    Any ideas on this. I've been advised to migrate my database table to MySQL
    to avoid crashing. I do not want to have to do this... especially with the
    app which is very complicated and embedded in a secure Coldfusion site.
    BAsically I am hoping that someone will give me some reassurance that I
    should not be so worried...
    Thanks.
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "TerryTech" <TerryTech@discussions.microsoft.com> wrote in message
    news:2CC2DE1E-5F0B-4A5C-A390-800D109FECFA@microsoft.com
    > I have a couple of websites where I use Access Databases to manage
    > data that is dynamically controlled by 1.Coldfusion Applications and
    > 2. ASP forms. Since setting these applications up, and having them in
    > use without any problems I have come across advise that Access is not
    > stable as a Web based database.
    > Any ideas on this. I've been advised to migrate my database table to
    > MySQL to avoid crashing. I do not want to have to do this...
    > especially with the app which is very complicated and embedded in a
    > secure Coldfusion site. BAsically I am hoping that someone will give
    > me some reassurance that I should not be so worried...


    Jet databases work fine on web sites, so long as you don't overload them
    (no more than about 1GB of data, no more than 255 simultaneous
    connections), can afford to be down occasionally for maintenance (such
    as compacting the database), and could live if you had to restore from a
    backup. Note that the 255-connection limit doesn't mean that you can't
    have more than 255 people connected to your website at a time, since
    database connections on a web site should be very transient things.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page