"Steve Mahon" <SteveMahon@discussions.microsoft.com> wrote in message
news:17D45771-05F8-490D-8CCF-FCF611591BA2@microsoft.com...
> How do I create and sync a local table from a subscription?
>
> I imagine I'm missing something simple. I currently have a sales order
> processing Access/SQL 2005 applicaiton we run on our SBS2003 lan. I'd like
> to
> run it disconnected from other locations and sync the changes. Reading
> trough
> the books online, it looks most like the Sales Force Automation (SFA)
> scenario using Pull Merger Replication.
>
> I follow the steps creading a distribution with Management Studio. Just to
> test I created a publication that includes all the records in the
> AdventrureWorks SalesTaxRate(Sales) table. It all seemed to go well with
> no
> warings.
>
> Next I installed sQL 2005 Express on a laptop including the replicaiton
> option. In management Studio Express I launch the subscription wizard and
> all
> seems to go well. I follow the steps in the wizard and receive no
> warnings.
> The subscription shows up under local subscriptions.
>
> I expected the tax table to show up in the local database I selected in
> the
> subscription wizard, but it has not shown up. What am I missing?
>
>