Deleting data from 2 databases

[abc123]

Need a trigger that deletes data from SQL and access database simultaneously.
If the user deletes one or more records from a table the trigger on deletion should add a record inot a temp table.Now the records here in should contain all fields that are a part of of a common ID based indexin the table fromw which the user deleted the records.
If the table doesnt exist, it should be created by the triger.

Would be vey nelpful if anyone could come up with a solution.
Plz do help me out.
Its very urgent.


Regards:
abc123