Creating a Trigger on Access
Hi,
I am trying to create a trigger to update a datetime field when a user
logs in to their account. Is there a way to create a trigger that
updates a field when the table is accessed? The only other possible
way I can think of to accomplish this would be to write code that
updates a field on submit so that it trips the trigger I have to update
the time. This does not seem especially efficient, though.
.
Relevant Pages
- Re: Triggers - Inserted and Deleted Tables
... If you have a DML statement that affects more than one row, ... trigger will fail - I mean, you won't get an error, but the trigger action ... SELECT @OldBalance = Balance ... and I update an account holders checking and savings account. ...
(microsoft.public.sqlserver.programming) - Re: call to xp_cmdshell from trigger problem
... I'll look this over maybe there is something we missed in the vbs script ... >> account. ... >> script that is called by the trigger the client get nothing. ...
(microsoft.public.sqlserver.server) - RE: Msg 15404: Could not obtain information about user
... I understand that when you changed your DAEMON startup account from ... What is the type of the trigger MyTable_MyUpdate, ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
(microsoft.public.sqlserver.security) - Re: Trigger on D3 DM tables
... The logic for the trigger is no biggie but my wonder is 'where' it ... RUNTIME-ERRORS which might cause me a 'circular logic' error). ... Account ACCT has a table ACCOUNTS which has a trigger on data portion. ... Account USER has a qpointer to ACCOUNTS. ...
(comp.databases.pick) - Re: call to xp_cmdshell from trigger problem
... The application user is a SQL Server account and not a Windows user account. ... try a test and see if the client gets the required info. ... >> database and causes a trigger to fire and starts a process to notify the ...
(microsoft.public.sqlserver.server) |
|
