Skip to main content
Participant
January 12, 2010
Question

Forms to Access Database

  • January 12, 2010
  • 1 reply
  • 478 views

Hi, I'm looking some advice on working methods with Internet Forms and Databases.  I want to have an Internet Form to send data to a database.  As far as I know the only way to achieve this is through PHP an MySQL.  I just wanted to know is there another way of doing this and if not, what is the best way of starting into this problem, I haven't found much in the way of tutorials in this?  Any help would be greatly appreciated.

This topic has been closed for replies.

1 reply

David_Powers
Inspiring
January 12, 2010

Thread moved to Dreamweaver Application Development forum, which deals with database-related questions.

PHP/MySQL is one way to do it, not the only way. To insert material in an Access database, you could use the ASP server behaviors in Dreamweaver. This requires a website that supports ASP. However, before embarking along that route, you should be aware that ASP is a dying technology. Microsoft stopped developing it about 10 years ago. It's still widely used, but if you have never used ASP before, I don't think it would be a wise choice to start now.

The alternative to PHP (at least if you want to rely on Dreamweaver to create much of the code for you) is ColdFusion. However, I'm not sure if ColdFusion is easy to integrate with Access.

Final thing to consider: Access is OK for small websites that don't need to store much data and don't get a lot of traffic. However, it was originally designed as a small office tool. It's not really suitable for use online.

Participating Frequently
January 12, 2010

I'm with David.  Suggest php & mysql.  Mysql will take a while longer to get the hang of and does not have some of the visual tools that Access has but it is far more robust, efficient, quick, and will be around a lot longer that classic asp (which I use a lot and am trying to move to php more and more) supported databases.  As David said classic asp is not being supported and enhanced.  While it is very good, should web development change in the future you may find yourself marooned with a platform that cannot take advantage of newer web technologies and techniques.