Posted by Steve on 10/11/06 18:40

Dale wrote:
> Access 2000 connected to SQL 2000
>
> Is there a way to initiate Sql Replication via code from within Access?
>
> All Replication jobs are setup to run on demand. I would like to be
> able to click a command button in Access to start the jobs.
>
> Can someone point me in the right direction?
>
> Thanks
> Dale

In a VBA module in Tools/References check Microsoft SQLDMO Library
While in the module look at the SQLDMO objects in Object Explorer.

http://msdn.microsoft.com/msdnmag/issues/01/05/sqldmo/
http://www.replicationanswers.com/Script2.asp

• Next in forum: Re: SQL 2000 - Initiate or Force Replication
• Prev in forum: complex(?) query
• Thread view: Re: SQL 2000 - Initiate or Force Replication

[Reply to this message]