Very Computer

I'm trying to replicate SQL Server 2000 database with Access 2000
database. The database is protected by a workgroup information file.

I consulted the help file and did the following.

I created a new subscriber using the type "Microsoft Jet 4.0 database
(Microsoft Access)" but this type does not allow me to choose the
workgroup information file(mdw) file for the database. Because of this,
SQL Server could not open the database as it is protected.

I then tried creating subscriber with "ODBC data source" type. I
successfully added a system DSN to the database with the correct
workgroup information file(mdw) but it could not be seen in the Push
Subscription Wizard.

Can anyone help me out?

Thanks in advance.

Hello,

I've tested the behavior that you mentioned and it is true that Jet OLEDB
doesn't allow me to specific mdw and while using the ODBC data source, the
ODBC data source is not listed in the Push Subscription Wizard. (The OLD DB
data source will create a linked server while the ODBC data source will
create a remote server).

You may try the OLE DB data source which uses the OLE DB provider for ODBC
driver to see if it is helpful:
1. Create a new subscriber.Select the OLE DB data source.
2. When adding the linked server, choose MS OLE DB provider for ODBC driver
as the provider. Enter Product Name, enter the DSN name as Data source,
MSDASQL.1 as the Provide String, and enter the full path to the database as
Catelog.
3. When the linked server is successfully created, you should be able to
create the subscriber which can be listed in Push Subscription Wizard.

I hope this helps!

Jun Chen

I?ve been "encouraged" to share this helpful information from our lawyers.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

Thanks.