Upload an access database which connects my ASP website?

Question

Hi there. I'm a bit of a beginner when it comes to dynamic websites. I have built an ASP site offline using my local machine as a test server. The site makes use of a Microsoft Access database. If i now want to put the site online, (ie, using a Remote server - as Dreamweaver calls it), how do i do it? Do i need to convert to SQL? Do i upload the MDB? Any advice would be great. (My webspace supports MySQL). Thanks.

Answer 1

yes ASP will only work for a windows server with asp support there is an apache:asp moduale however i know not too much about it.



you can use an IIS server and host from your home but that means leaving your computer on allowing internet connects to port 80 through port forwarding your fire wall and it limits your bandwidth.



I think godaddy offers asp windows hosting at 5 or 6 dollars a month.



or you can convert everything to mysql and php and use a php supported free web host.



in my case there wasnt any support for access upload so i had to write a special php to read a delimited text file into the mysql database. as well there are other limitations in my case such as socket support is off so no mailers or access to paypal return valadation [paypal works just cant get a return value through fsocket] and somepoeple have abused the server host and have gotten them blocked from facebook so linking a business site through them causes a blockedd server message



if you can afford it get hosted space from a host provider

Answer 2

If you intend on using the access database, you have no choice but to get windows hosting. Then you connect to the database via php or asp.

Answer 3

Use mysqldump to get a copy of your table structure and data. Then import them into your database, create the tables and load the data. Access you can use to connect to the MySQL database by the way. You just need the MyODBC driver.