Posted by Jim Devenish on 11/11/06 16:44

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

• Next in forum: Re: Trigger on an Access database?
• Prev in forum: Re: How do i find indexes of the columns in SQL server 2000???
• Thread view: Trigger on an Access database?

[Reply to this message]