Access db on website

**opus88** · 09-09-2004

I hope I'm in the right section for this question.
We have an Access database used for a small website. Every time we go in to make changes on the database, it knocks the site offline. This means we have to restart the webserver (which hosts 6 other sites, all small) even though all other sites are running fine. And even this does not always get the site up and running again.
Sometimes it comes back as Page Cannot Be Displayed with varying line numbers as the error. Other times it just says something about could not find the site or can't connect or something like that, but no specific info. Nobody can figure out why it is happening or what to do. (The original programmers have disappeared from Earth, but did admit they had never used Access as a backend except for this site.)
Any ideas? We're going CRAZY . . . and it's hurting our business!

**HappyBeaver** · 01-03-2005

http://members.iinet.net.au/~allenbrowne/bug-09.html

Does this help?

patriotcow · 01-03-2005

get mysql

**D-A-L** · 01-03-2005

Theres nothing wrong with using Access as a backend for a small site, although as Pat said, mysql is now the prefrable database type.

Every time we go in to make changes on the database, it knocks the site offline.

How are you making these changes? directly from a web page running queries or downloading the whole thing and then re-uploading changes and replacing the database?

patriotcow · 01-03-2005

Microsoft products for websites never seem good they seem to be good for game servers but not for databases. I would recommend switching to postgres or mysql. Or use flatfile lol

**DJDK** · 03-03-2005

as stephen and dal said mysql is the better database to use. I have attempted to use access for a site with no avail. used MySQL almost imediate. I know you will have to learn some new script but by god its worth it.

patriotcow · 03-03-2005

Grab the sams teach yourself php in 24 hours and sams teach yourself mysql in 24 hours, I learnt alot from them in fact everything you need to know how to learn the rest