First off I see alot of posts in this forum about connection errors with MySQL using ASP on a windows box. My answer DUMP IT ALL and get a Linux Box!!!!!
ASP & Access go hand in hand just like PHP & MySQL.
Try Mixing Bill's Stuff With OpenSource and your bound to have problems.
Hey Gang thought Id share the following information. And if there are any Q's give me a yell.
One of our sites is a yellow pages site with over 52,000 business listings. BUT the site runs on ASP with a Windows box.
The problem is that as our site has grown we sometimes have over 300 users online at the same time and the ASP is REALLY SLOW when there are multiple users online.
Problem there I know. So we are in the process of porting the whole site over to PHP. We have found that there are PHP sites out there which EASILY support over 30,000 users at the same time and dont crash. We have 8 PHP sites and they all run great. Well were making #9 by porting this thing over.
Things went great getting the structure together. But the data conversion was terrible.
I finally found a great FREE utility (yes there are upgraded versions)
Its called Access Dump! available from Internet2Internet.com
http://www.intranet2internet.com/public/default.asp
The utility does not make everything seamless, you still need to do a bit of table structuring. The util supports cvs, txt, .sql and runs pretty stable even for converting a 52,000+ Database.
So for all of you running ASP with Access who are having nothing but problems and you
want to get to PHP with MySQL this utility will help even the novice dump the data and its very useful for the experienced webmaster as well.
Take care all