WebProWorld Part of WebProNews.com
Page One Link To Us Edit Profile Private Messages Archives FAQ RSS Feeds  
 

Go Back   WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Subscribe to the Newsletter FREE!


Register FAQ Members List Calendar Arcade Chatbox Mark Forums Read

Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here!

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-15-2008, 03:32 PM
WebProWorld New Member
 

Join Date: May 2008
Posts: 2
abc123 RepRank 0
Post Deleting data from 2 databases

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
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting e-mail address abmehta Internet Security Discussion Forum 0 05-07-2008 12:54 AM
Why are you deleting my post? gamefowlworld Marketing Strategies Discussion Forum 5 12-09-2005 11:08 AM
Deleting Old Web Pages maxsun Search Engine Optimization Forum 1 08-20-2005 07:17 PM
Deleting X rated sites hal Internet Security Discussion Forum 0 09-25-2004 11:21 AM
deleting pages mossop Google Discussion Forum 1 06-29-2004 11:01 AM


Search Engine Optimization by vBSEO 3.2.0