Re: Triggers for access row

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wanda Li (wandali_at_rogers.com)
Date: 12/02/04 

Date: Thu, 02 Dec 2004 05:55:16 -0800

Thanks for your response, however, your suggestions don't fit my
currently situation:

1. I have an application which opens the database with just one login
name, meaning it will open up the database anyway, but then the
application will then check the user's input user name and password with
the User table (tblUser, created by me). That is to say, even you have
"Insert" or "Update" triggers, the user will be the same all the time.
It doesn't help...

2. Even I create extra columns in the tblUser table, it doesn't work
either. As I have to modify the "last use" field through coding in my
application, which is something I can't do, as all applications are live
now, I can't change all single application, with the fact that I have
more than 20 applications using this approach...

So, what would be the best way to do, the only thing I can think of for
now is, the application will read the tblUser table, that's why I am
thinking of is there a way to create a trigger for "SELECT"? PLEASE HELP

Thanks in advance. Any suggestion would be greatly appreciated.

Wanda

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Hyperlinks
    ... On my main form of a database I have several command ... that hyperlink to applications. ... The ones that hyperlink to applications pop ... application opens. ...
    (microsoft.public.access.formscoding)
  • Re: Tracking Log In and Log Out times of Users
    ... The fact that the database is on the server should be irrelevant. ... Type mismatch and then highlights Set rst = ... On my startup form, (that opens every time the database is open, ... I then went to the load ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • Re: Code causes error 2486 in access 2000, IPF in 2002
    ... Compact the database to get rid of this junk: ... Allen Browne - Microsoft MVP. ... Windows 98 machine. ... update queries and opens another form - ...
    (microsoft.public.access.formscoding)