FN-FORUM: ASP/MS Access Help

date posted 24th August 2007 09:52

Hi All,

I have created an ASP web page which is updateable via MS Access db. All data
is stored in 1 table in the db, I have created a 2nd table which is identical
and is used to display the data for the live page.

Basically the user can make amendments to the web page and when there happy
with it they click a button and all data is transferred from one table to
another.

At the moment I have created 3 script files:
script1: deletes the live db redirect to script2 with ID1
script2: gets the ID1 of the none live db, if EOF redirect to home page
script3: writes ID1 to live db, redirect back to script2 with ID2

This works only if the ID numbers are in consecutive order, unfortunately
they're not.

Can anyone suggest another way of doing this?

TIA

Peter