Database Discussion - data deletion from 2 databases simultaneously

Print Page | Close Window

data deletion from 2 databases simultaneously

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25726
Printed Date: 28 March 2026 at 7:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: data deletion from 2 databases simultaneously

Posted By: abcdef
Subject: data deletion from 2 databases simultaneously
Date Posted: 15 May 2008 at 8:48pm

Deleting data from access database-we need a trigger that also deletes data from other database(sql).

If the userdeletes one or more records from a table the trigger on deletion shud add a record into the TempTable. The records shud contain all the fields that are part of the a index type id from the table from whihc the user deleted the data. If the table doesnt
exist, it shud be created by the trigger.

Urgent.Plz