Jim Devenish wrote:
> We have an Access database with Access front-end to Access back-end.
> Another company has installed a separate application using SQLServer.
> At present certain information in the first application is entered
> manually into the second. We wish to automate this process.
>
> The other company is proposing that the SQLServer application sets up
> a trigger on a selected table in the Access backend. When a new
> record is added, information can be transferred to the SQLServer.
>
> I am interested to know if this is really possible. I have found in
> BOL that the Access database can be set up as a linked server to
> SQLServer. Is this way to handle this and is it then possible to set
> up a trigger?
>
> I am not the person who will be doing this but would like to know if
> it possible and, in general, how it is done.
>
> Jim

When using Jet tables (tables in an MDB file) there is no support for triggers.
You can of course use Access as the front end use a server back end and choose
one that does support triggers.

If you didn't misunderstand what the other company said then they are not very
familiar with Access.

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