Access Database on WEb Server

[TerryTech]

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.

 

[Dirk Goldgar]

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.

 

[Texis]

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.

 

[Texis]

I volunteer at a non-profit food pantry. We use Access to track volunteer
hours on stand alone PCs. We recently set up a thrift store at another
location. I would like to use the web to allow the volunteers to track their
hours from either location on a server based Access location. How do we do
this?