Retrieve

[mooseless05]

Hi is there any way to link the results of a query back into a table, I am
setting up a system whereas we have two main databases and a website hosted
on Win 2k server using iis with the results displayed in ASP. Basically the
query brings up the data that is required and I then need to send these
results back into a table on the second database. I have set up "delete
query" and then "append query" to stop the replication of data which are both
set up automatically to work using a macro, this works except for one
problem, the autonumber increments upon each append so none of the linked
items work as technically the data no longer exists.

Any help would be much appreciated.

Win 2k Server SP4
Office XP Pro
IIs 5.0

 

[John W. Vinson]

Hi is there any way to link the results of a query back into a table, I am
setting up a system whereas we have two main databases and a website hosted
on Win 2k server using iis with the results displayed in ASP. Basically the
query brings up the data that is required and I then need to send these
results back into a table on the second database. I have set up "delete
query" and then "append query" to stop the replication of data which are both
set up automatically to work using a macro, this works except for one
problem, the autonumber increments upon each append so none of the linked
items work as technically the data no longer exists.

Well, if you don't want the autonumber, don't use an Autonumber field in your
table; or revise your Append query to append a Long Integer value into the
autonumber field.

Since you don't describe your table structure, or post the query, or post the
macro code, it's more than a bit hard for anyone here to debug it for you!

John W. Vinson [MVP]

 

[Robert]

To reset the autonumber back to 1 after deleting a table, Compact and Repair
the database (it's under Tools/Database Utilities).