Access 2000 and MySQL queries

[northants]

Hi,
Word of warning, I'm fairly new to ASP's
I have made been working on a learning environment which will collect demmografic information on learners before they enter the actual information site, so far I have obtained most of my information from Wrox (beginning active Server Pages 3.0)

http://www.wrox.com

Everything seems to be working very well on my PC which has PWS (personal web server) installed. The data base used is Access 2000.

I now want to publish, however the institute at which I work, (Who use windows NT) have been prommising to install IIS on one of the servers for some time now, (they suffer from security stress) I can no longer wait as the project is late already. So I have contacted other external service providers who use Linux Chilisoft and MySQL. Now I am confused, How do I, and (can I) upload something I know that works on to a different system? Do I need to install MySQL on my PC and is it possible? as my machine has Windows as an opperating system?
Please can somebody suggest the best way ahead with regard the institute or the outside provider, either option will be acceptable.
Your sincerely

 

[vpekulas]

Hi,
in my experience, you can run most of the ASP scripts on Chilisoft, however you will not be able to connect to your access database. MySQL would be the way to go, you can install MySQL on your computer, just go to

http://www.mysql.com/

for any How-To questions you have.
I would suggest to always use MySQL rather then MS Access, it's faster and more usefull in most cases. I'd also suggest that you use PHPadmin when it comes to administrating you MySQL db online.
If you have any problems contact me (vpekulas@mail.com).