We use an Access database on our website to maintain member and event information. All pages on the website are created/maintained using Dreamweaver CS4. I need to do the following from a web page when requested:
1. Lock affected tables from user update while the following is executed:
a. Delete all records in three different tables.
b. Run three queries to extract information from a member table and add them to the three tables.
c. Delete records from the member table.
I've tried a couple of approaches and researched how to do this, but with no success. Using Dreamweaver, do I need to create record sets or just open a connection and execute the SQL?
Can I include the connection string or does it need to be redefined in the web page? As you can see, I'm floundering.