Trigger with MDB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iwasinnihon - 30 Nov 2006 21:51 GMT

I was wondering if there was a way to setup a trigger on a MDB. I know
you can with a ADP, but I can't seem to find that choice when you right
click on a table.

Reply to this Message

Rick Brandt - 30 Nov 2006 21:57 GMT

> I was wondering if there was a way to setup a trigger on a MDB. I
> know you can with a ADP, but I can't seem to find that choice when
> you right click on a table.

Tables in MDB files do not support triggers. It works in an ADP because the
tables are on SQL Server (which does support triggers).

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

ruralguy - 30 Nov 2006 22:01 GMT

Sorry, there are no triggers in tables in Access MDB's.

>I was wondering if there was a way to setup a trigger on a MDB. I know
>you can with a ADP, but I can't seem to find that choice when you right
>click on a table.

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message