Auto Add Record TRIGGER??

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

Lee T.

We need to keep track of our keycards.

When a user loses, damages or ??? one of the cards they
are issued a new one. The person issuing the new one has a
third party product the records how many times that a
person has been issued a card. Management wants someone
to keep track of why they needed a new card and what
happened to the old card.

The vendor db stores the person and how many cards they
have been issued.

I can attach to this Vendor db and pull that data. What I
am looking to do is to create a table on my own the links
the name and the number of "new" cards. I would like
someway to auto populate my table with a record for each
of the lost cards.

My guess is that I need some kind of macro to be triggered
that will add a record to MY table when the card issuer
adds a new card to the VENDOR table. I don't know to, in
access, make a "trigger"...

TIA

Lee T.
 
Lee,

You say that you can attach to the Vendor Db and pull that data. Are you doing
that through Access? If you are, you should be able to just create a linked
table. You won't need any kind of "Trigger" for when a new card is added to the
VENDOR table because all the vendor records will be available to you anytime you
work through the linked table.

I have a request for you. Would you provide me the vendor's name and contact
information. Would you also comment on how well the current system is working. I
have a future keycard application to do.

Thanks!
 
PC,

Thanks for the idea but I have linked the table. They
are both (mine and the vendor's) access databases. It is
after the person doing the badges/card keys updates the
VENDOR database that I want something that would notice
that change, fire off a procedure that would append a new
record to a table in my database.

I can do stuff like this in Sybase and Oracle and ...
but I don't know how to get something in access to do this.

A different department handles the badge and card key
stuff (they put the picture and badge onto the card key).
I'll as them for the vendor info as I don't have it, just
the database/tbl to link.
 
Lee,

If you are linked, why do you have to do an append? When the Vendor database is
updated, the new record should automatically appear in your link table!

Thanks for looking in to getting the vendor info for me!

Steve
PC Datasheet
 
I can do stuff like this in Sybase and Oracle and ...
but I don't know how to get something in access to do this.
Click to expand...

If you use a access project, then you have server side scripting, and also
have the triggers you need.

However, I not sure if you have control over what database engine. As you
mentioned, Oracle has triggers, but MySql does not. And, the same goes for
using the JET engine with ms-access. So, really, this is not a problem of
ms-access, but in fact which data engine you choose (you can even use
ms-access with oracle, and once again..you would then get triggers).

So, you can use sever side code and triggers with ms-access, but you have to
use the other data engine provided on the office cd (access2000 and later)
to get these features. If the application you purchsed does not use a data
engine with triggers, then you are out luck. However, ms-access will use,
and work fine with data engines that have triggers.
 
PC,
The linked table doesn't have all the data I need and
the number of cards that they have had is an integer. I
want to create a single record in local ACCESS table for
each of the "cards" that they have had.

So... Linked table Name Cards nameID
Loser Doe 5 48

Local Table NameID Card#
48 1
48 2
48 3
48 4

We have to keep track of the demise of each card and the
date lost/FUBARed and date replaced.

Digital Door Entry cards:
Continental Instruments Systems Card Access 3000

Picture taking software and printing a badge
(it is a thin sticky vinyl thing that is pasted
on the digital door badge)
IDWorks
 
Back
Top