Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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)
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page