M
mcourter
is there a good way to approximate a sql trigger within access -
without using a forms after insert event?
without using a forms after insert event?
J
John Spencer
None that I know of or have heard of.
The only way I know to emulate a trigger is to use form events. Unless you
are using a different backend than JET. For instance, you could do this if
your database engine was MS SQL, Oracle, etc.
The only way I know to emulate a trigger is to use form events. Unless you
are using a different backend than JET. For instance, you could do this if
your database engine was MS SQL, Oracle, etc.
M
mcourter
right.
so no way to get a macro to immulate a trigger by calling some vba code?
so no way to get a macro to immulate a trigger by calling some vba code?
J
Jerry Whittle
Triggers would sure be nice. Access is event driven and unfortunately tables
do not have events. If you are entering data directly into a table, there is
not way to automate something like putting a foriegn key into another table.
If you are doing appends or inserts into a table, you need to handle anything
trigger-like while you are doing it.
I'll add that sequences would also be nice instead of autonumbers.
do not have events. If you are entering data directly into a table, there is
not way to automate something like putting a foriegn key into another table.
If you are doing appends or inserts into a table, you need to handle anything
trigger-like while you are doing it.
I'll add that sequences would also be nice instead of autonumbers.
M
MH
If we're compiling a wish-list, can we have T-SQL as well?
)
)