Please explain the exact process. You may be able to use a sub-query with a combination of append/delete/update queries with some parameters.
Access does not support stored procedures, but you could use ADO, or, you could try using SQL Server MSDE if you are interested in learning. MSDE does support stored procedures.
Sal
|