For those of you that use MS Access to provide dynamic content on your websites (or your customer's websites), have you ever had to make a quick change to your database? What do you usually do? Ftp the database to your desktop change it then upload it back ... right? What if you database is several megs in size? What if you have a steady stream of visitors? I will show you a couple of scripts that will allow you to copy your live DB to a backup so that you can download the backup and a script that will copy your backup DB to Live.
Here is an usefull script to copy and compact your Access DB
This tutorial will walk you through the process of creating a form that a user can fill out, the results are inserted into a database and a personalized mail is send to the user based on a template. I am using a url parameter to pass the user's name to the template page that is send to the user by mail.
I created a pdf file of this tutorial. You can download it by clicking on the Code Download link in the blue properties box.
Applying a UCase (all uppercase) or LCase (all lowercase) to a word or sentence is a standard function within Dreamweaver. Applying a UCase to the first letter and the rest a LCase in the word or sentence needs some manual coding. This short tutorial shows you how to use these stringfunctions.