Access Database on WEb Server

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14045-access-database-on-web-server.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14045
should not be so worried...
Thanks.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

"TerryTech" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14045
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14045
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)