Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-29 : 12:09:57
|
| Bruce writes "When I use SQL server merge replication with an Access 2000 database that uses a secure Access workgroup other than system.mdw, I can't configure the SQLMerge object to use the secure workgroup:'Anonymous subscriber oSQLMerge.Subscriber = "AnySubscriber" oSQLMerge.SubscriberDatabasePath = "C:\MyAccessDb.Mdb" oSQLMerge.SubscriberDatasourceType = JET4_DATABASE oSQLMerge.SubscriptionType = ANONYMOUS oSQLMerge.SubscriberSecurityMode = DB_AUTHENTICATION oSQLMerge.SubscriberLogin = "JamesKilroy" oSQLMerge.SubscriberPassword = "LetMeIn"The problem is User "JamesKilroy" is in secure workgroup "MyGroup.Mdw" and not "system.mdw" so the SQL Merge object fails. I have searched all over for a way to pass a different workgroup but to no avail, can you help? Thanks." |
|
|
|
|
|
SQL Replication Using ActiveX control