Home > Archive > MS SQL Server > December 2005 > Making triggers to allow use in Access









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Making triggers to allow use in Access
wenzlow9@yahoo.com

2005-12-13, 1:23 pm

Greetings. I want my SQL tables (SQL Server 2000) to be edited in
Access. It appears that I can either create relationships in SQL or
make triggers in SQL to make this happen, though it looks like going
the trigger route will work better for me. I want a trigger that
allows any insert, update, or delete in Access, on a SQL table, no
matter which column is modified, to not be denied. By denied, I mean I
am trying to not have the "Drop Changes/Copy to Clipboard" window
appear every time me or someone else tries to change data in Access.
I'm just looking for some code, or where I can see some examples. That
would be great help for me. Thank you in advance!

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com