Event handling with DW MX 2004?

Question

For an outside project for a friend, I want to set up a simple club registration program, and all I have to work with is Dreamweaver MX 2004. I use Visual Studio.Net/SQL for work, and if possible, would like to have DW work like it in terms of the same program being event driven to capture, edit and save form data
to an Access file, rather than pass the form data to a second program for editing then via session variables to a third one to save it. Cumbersome in the extreme

So can this version of DW do this? I'm guessing it might have to be done with Javascript if so, which I don't really have, at least to a comfort level beyond shaky. And if so, what might be needed on the host side? I think they are hosted on GoDaddy (I have no control over that).

TIA!

elaine

pziecina · Accepted Answer

Export Access data into MSSQL. Access is too slow and under powered for use with web applications.

Nancy

https://forums.adobe.com/people/Nancy+OShea wrote
Export Access data into MSSQL. Access is too slow and under powered for use with web applications.

I know many do suggest doing this, but unless one knows the differences between access sql and MSsql, it is not one i would recommend, as for anything more than a very simple db it can cause more problems than it is worth. Besides the MSsql server management tools does offer a very good visual database creation tool. The main problem for someone who does not know sql is keeping the query, (etc) creation simple, and learning the ui.

BenPleysier · Answer

Dreamweaver is a glorified word processor designed to facilitate web creation. As such it will not do the work for you.

For what you are intending to do, you will need a database (not Access) and a server-side code translator. The most widely used systems use PHP (server-side code) and MySQL (database).

You could start with this tutorial PHP CRUD Tutorial (part 1)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded