Is there any way to place a "trigger" on a table (similar to what can be done in Oracle, SQL Server) so that when a table/field is updated an action can be carried out? I have a pocket access database that sync to an Access 2002 database on the LAN. Using Microsoft Activesync, want to be able to run a query to update table b if there are updates in table A.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Triggers in Access?
- Thread starter dchaff
- Start date
LittleSmudge
Programmer
Access does not support Table Triggers.
How much control do you have over the database?
Could you ensure that any Form or Code that does update the table also called a procedure somewhere that does the tableB update for you.
'ope-that-'elps.
G LS
How much control do you have over the database?
Could you ensure that any Form or Code that does update the table also called a procedure somewhere that does the tableB update for you.
'ope-that-'elps.
G LS
- Thread starter
- #3
Since it is Activesync that does the updating, I am not in control of when the end user will run activesync. Activesync updates the table a, so I was trying to figure out how to know when the table was updated and then run something to update table b. Table a is not really tied to any form or anything.
LittleSmudge
Programmer
I'm not familiar with Activesync dchaff and Access 2000 help seems as knowledgable about it as I am. Any pointers so that I can learn? ( & then be in a position to advise. )
G LS
G LS
- Status
Similar threads
- Locked
- Question
- Locked
- Question