Using Access databases with Web sites

[Phonik]

Hi,

I curently have a website that has a registration page on it that uses a simple access database that contains a single table with the same fields on as that of the reg. form. What I want to do, in one way or another, is to make some sort of macro that starts once some datails have been submitted to the database using an SQL statement I made within Frontpage, send an email to the registrant telling them what there customer number etc (autonumber in database) and various other welcoming messages etc.
The SQL statement is along the line of INSERT INTO...

Am I thinking along the right lines with a macro or some code or is the access database literally rendered to a table/number of table and thats it?

Cheers folks

 

[KeithG]

Access isn't the best RDBMS to use for a Web Page because it is a file/server database not a Client/Server database. Also Access does not support triggers. You could use MS SQL Server express as your back end witch is a Client/Server RDBMS and it does support triggers.

 

[Phonik]

Hi! Thanks for your reply.
Where would I source MS SQL and how would I set it up. Not in details but would I need to install it on web server etc..

Thanks

Gaz

 

[Oldsoftboss]

http://msdn.microsoft.com/vstudio/express/sql/

 

[Phonik]

Great. Downloading as I type. Can you recommend any good online tutorials as I am begginer with using SQL as you prob gathered. And no doubt I have my work cut out for me right?

Many thanks for link!

Gaz

 

[Treason]

if your server supports asp code... then you can automatically email whatever you want from the database with a webform.

do a google search for email asp scripts