Help- New to Access

[Guest]

Hi there,

I'm good with MS Excel VBA coding, now I'm building access database and
would like to build trigger to track changes. Please direct me to web link
for any helpful information, so that I could do some studies before the
actual work starts.

Thanks.

 

[Stefan Hoffmann]

hi,

I'm good with MS Excel VBA coding, now I'm building access database and
would like to build trigger to track changes. Please direct me to web link
for any helpful information, so that I could do some studies before the
actual work starts.

http://support.microsoft.com/kb/197592


mfG
--> stefan <--

 

[Albert D. Kallal]

Hi there,

I'm good with MS Excel VBA coding, now I'm building access database and
would like to build trigger to track changes. Please direct me to web link
for any helpful information, so that I could do some studies before the
actual work starts.

Thanks.

The availability of triggers is going to depend on what data engine your
using with ms-access. the last 4, perhaps 5 versions of ms-access have
shipped with two database engines for use with ms-access. The JET data
engine does not have built in triggers, so, you normally use the before, or
after update event on a form to run code when a record is updated.

The other data engine that shipped with ms-access for many years does have
triggers, and that engine is 100% compatible with sql server. This engine
supports triggers at the table level.

So, you have two approaches, depending on which data engine you decide to
use with ms-access.

It not clear if you have a choice of what data engine your going to use with
ms-access or not.

 

[Guest]

Thanks for the information Stefan.
That link only showed me how to set the Audit trail from Forms level. But
I'm not using forms for now, directly changing the data on the table. Hence
would like to retain the values before change on another table.
Any further suggestion would be grateful.
Thanks again.

 

[Guest]

Kallal,
My approach is the 2nd one you mentioned. Would like to build trigger at the
table level. Is there any a document or information available out there on
the web.

Please & thanks.

 

[John W. Vinson]

My approach is the 2nd one you mentioned. Would like to build trigger at the
table level.

Then you cannot use Access. Microsoft Access does not support table triggers.

John W. Vinson [MVP]

 

[Guest]

Great...thanks John.
Now I have a reason to spend more days on R&D.

 

[Albert D. Kallal]

Kallal,
My approach is the 2nd one you mentioned. Would like to build trigger at
the
table level. Is there any a document or information available out there on
the web.

Ok, if you thus do need table level triggers, then your going to ms-access +
sql server.

You don't mention what version of ms-access, but on the office cd there is a
free edition of sql server for use with ms-access.

If you don't have any sql server tools, then you can create what is called a
adp project.

So, you do have table level triggers available, it just a matter of what
database engine you use with ms-access.