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)