I want to be able to let a user demo an online application (database
driven), adding, modifying records and details.
When they have finished, I want the database to reset back to its original
state where all the information that the user has just entered isn't
available to other users.

Any ideas on how to do this? I'm using ASP code and IIS5 (MS Access 2000 database)

Help would be greatly appreciated.

Thanks,
Simon J

well, the only way I can see to do this, is by using the global.asa file to nuke the database contents when the session ends... but you'll get into integrity issues because what if two people are using the database at the same time, and one stays longer, the other session ending will nuke the databases. you either go that route, or make a page that will run a bunch of delete commands, and run it yourself once a day or something.

-tutorial on the global.asa here:
www.basic-ultradev.com/articles/UserTracking/index.asp

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/