Anyone did the replication from SQL Server 2000 to Access Mdb file? I need
When I tried do that with SQL Merge Control, I got the following error
The process could not initialize 'MsJet'. Check to see if the component
is registered correctly.
I have no idea with this message, what should I do?
The code is just like this:
Set mobjMerge = New SQLMERGXLib.SQLMerge
'Set up the Publisher.
.Publisher = "MyServer"
.PublisherDatabase = "DB1"
.Publication = "DB1"
.PublisherSecurityMode = NT_AUTHENTICATION
'Set up the Subscriber.
.Subscriber = "MDBSUB"
' MDBFileSpecification would be something like
.SubscriberDatabasePath = "C:\Temp\Test.mdb"
.SubscriberDatasourceType = JET4_DATABASE
.SubscriberSecurityMode = DB_AUTHENTICATION
' JetDatabaseUserID would be something like "Admin"
.SubscriberLogin = "Admin"
.SubscriberPassword = ""
'Set up the subscription.
.SubscriptionType = ANONYMOUS
.SynchronizationType = AUTOMATIC
'Create the database and subscription.
'.AddSubscription EXISTING_DATABASE, NONE
'Synchronize the subscription.
.Initialize ' << error occurs here