473,480 Members | 4,985 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

SQL 2000 - Initiate or Force Replication

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

Oct 10 '06 #1
2 1904

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

Oct 11 '06 #2

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

Oct 11 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1827
by: Steve | last post by:
We've recently got a new Server in. The server has 16Gb of RAM, 8 cpus etc We now have a choice of sticking with Windows 2000 Advanced Server or going with Windows 2003 Enterprise edition. ...
2
4273
by: Robert M. | last post by:
Information: Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server Enterprise Edition. SQL Service pack is 3a. Member of domain ABCDomain. Server A is going to function as a...
2
5371
by: Oleg Ogurok | last post by:
Hi all, After adding a user to active directory, its state is set to Disabled until the next replication occurs or until I manually force the replication using Active Directory Sites and...
1
2165
by: smahler | last post by:
Hi all, Here is my situation. I have an application that uses SQL 2000. The client has a program that uses MSDE. The client MUST have the MSDE version of the Database. What I have done is to...
0
1230
by: eroepe | last post by:
Hi, Does anyone have experience in replicating between two servers running 2000 with a database in 65 compatibility mode? Here's my situation. I'm setting up two servers. Server 1 is the...
1
1626
by: loosecannon_1 | last post by:
All my queries are being blocked while the tables are being replicated and it is causing some 2 minute blocking. Is there a way for the Replication to allow dirty reads because I really don't...
3
2216
by: datapro01 | last post by:
I am a DB2 DBA that has been asked to become familiar enough with SQL Server in order to become actively involved in its installation, implementation, and to review database backup/recovery...
1
2089
by: betbubble | last post by:
I replicate (transactional replication) my data entry database to a read-only database. Both are SQL 2000+SP4. The web server reads the read-only database. At times, there will be lots of changes...
0
1099
by: tsharp89 | last post by:
We currently have SQL Server 2000 and have merge replication. We have the following process 1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'...
0
7040
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7041
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7080
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5331
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4772
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4478
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2980
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1299
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
561
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.