How to enable a Jet 4.0 database as a Subscriber (Enterprise Manager)

How to Install SQL Server 2000

How To

How to enable a Jet 4.0 database as a Subscriber (Enterprise Manager)

  1. Expand a server group; then expand the Publisher of the publication to which the Jet Subscribers will subscribe.

  2. On the Tools menu, point to Replication, and then click Configuring Publishing, Subscribers, and Distribution.

  3. On the Subscribers tab, click New Subscriber.

  4. Select Microsoft Jet 4.0 database (Microsoft Access).

  5. Select the new Subscriber from the list of Microsoft® Jet 4.0 databases shown. Enter the login name and, optionally, the password for the Microsoft Jet database. The Microsoft Jet database does not need to exist. If the database is new or unsecured, you must enter admin as the login name.

  6. If the database is not listed, click Add. In Linked server name, enter a name for the linked server (for example, enter the name of the Jet database).

  7. In Database path, enter the path and file name to the database. If the database is located on the same server as the Distributor, you can use local drive letters in the path. If the database is located on a different server than the Distributor, enter a UNC path. If the database does not exist, it will be created automatically when the subscription is initialized.