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
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
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.
I also tried creating subscriber using "OLE DB Data source" type. I
choosed "Microsoft Jet
4.0 OLE DB Provider" for the Provider name field. I enter the path for
the database in the
Data source field. And entered the Provider string which looks something
database=C:\Records.mdw". After clicking OK, nothing happened. Then I
checked around, I
found out that this subscriber is added into the "Microsoft Jet 4.0
Access)" type. Anyway, it still doesn't work. Now, I have another
problem, how to delete it
from the list.
Can anyone help me out?
Thanks in advance.