How can can i connect on msn from an other website?

How can I connect my Access database form and/or table to a page in my website made with Dreamweaver?

• I have an Access database that has a table full of information (CD names, artist etc), and a form that I can use to scroll through the information (next CD, previous CD), add information (add CD) or delete information (delete CD). I also have a basic website that I have made in Dreamweaver which is for my made up record shop that will sell the CD stock that I have listed in a table in my Access database. I want to connect the Access form or the Access table to a page of my website in Dreamweaver so I can browse through the list of CD's or browse through the form while on the website if you know know I mean. So like, I could go to my website and go to the 'Products' page and I would be able to see all of the CD's that are in the stock table that I have in Access. I will also be trying to develop a way of purchasing items on the website, making it e-commerce. Help with this would be appreciated too :) Any help at all with any of the above would be much appreciated, Dale.

• Answer:

  Not the way to do it. First you can not run Access on ANY web site unless the server is a Windows one, these are very rare. Second even then it is unlikely the owner will allow you to install Access on it. Third you can not safely provide a data connection to your own machine from the web pages. Fourth, you can not present an Access form on a web site, it is not a standard browser compatible form. the way this is done is to create a database on the site server. Usually this would be a mysql database. Then you use php to manipulate and read the data, and to create forms to enter data and read that data into the database. Also you will need to use it to handle site and user security. DreamWeaver is useless for this, you will need to learn to write your own scripts. Even if you could get this to work, Access is the worst possible database for remote connections, and is too clumsy for heavy or multiple usage. In any case to sell on line you will need to incorporate payment gateway scripts into your site, this will also require php and mysql.