Re: What's wrong with this trigger

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

After reviewing what the previous datbase developer did with the audit
tables I realized that there was no need for an identity field in the audit
tables. Eveything works fine now that I removed the identity fields.

I'm still learning all this on the fly as most of my experience is with
Access on it's own.

On a seperate topic, one thing in Access which was possible was to build a
query based on other queries. Is this possible with stored procedures
without creating Temp tables?

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Whats wrong with this trigger
    ... You can do a subselect that would be joined to another table. ... > After reviewing what the previous datbase developer did with the audit ... > tables I realized that there was no need for an identity field in the ... Is this possible with stored procedures ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Heartland Gets Religion on Security
    ... Over at DataLossDB, I inquired about adding a column for the ... > the audit didn't detect the vulnerability that led to the hack even though ... the assessor didn't do a thorough job either of reviewing them. ...
    (Pen-Test)
  • Re: For what reason would IRS send certified mail?
    ... I got one of those "we are reviewing your 2004 return" ... decided that I owed them some unpayable amount and I had two choices, ... My favorite story along those lines was the "mail audit" my live-in ... mortgage interest deduction. ...
    (rec.sport.football.college)
  • Local and remote copies of audit.log?
    ... Reviewing the man pages of auditd on CentOS 5, it doesn't seem obvious that I can log events locally AND send a copy to a remote log host. ...
    (RedHat)