How to write a trigger

[sabavno]

Hi

I am little experienced in Access, but never worked with SQL Server

My task now is to copy SQL table into my access table. Actually I only need to copy a few fields, not the whole table.
The thing is that I want it to be done automatically, say every week.

Please give some ideas on what should I start with.

I'd appreciate your help

Thanks

 

[scking]

I would recommend you ask this question on a group that focuses on SQL Server. I know they can set up maintenance events but don't know their limitations.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------

 

[Kleinen]

First link your SQL table in your Access Database.
Then make an update query to add the new info in your Access table.

 

[scking]

That is a very simple solution, however, it doesn't answer the original question of automating the process. And since SQL Server has this functionality built in it would probably be easier than developing the capability inside Access.

Management/SQL Server Agent/Jobs
This allows you to build T-SQL scripts and specify job steps and schedule.

----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------