How to setup Replication with Access

hi all,
I want to setup replication on Access Database.. I want data will be updated
in SQL Server from Access database..
1) Which replication type will be best suited (merge or transactional)
2) How I will setup subscription on Access database. Whenever I try to
create a push subscription I only found option to create subsription on SQL
Server database. Although I have checked "Hetrogeneous datasources such as
Access" option when creating publication.
any suggesstion or link to article will be highly appreiciated..
Thanks
Ansari
Hi all
I succeeded in creating push subscription to an access datatbase. But
whenever I snapshot agest want to apply initial snap shot the process fails
and give me the following errors
"The process could not initialize 'MsJet'. Check to see if the component is
registered correctly"
any sugestion
Ansari
"Ansari" <mudasar_ansari@.yahoo.com> wrote in message
news:O6I4OqSpEHA.1160@.tk2msftngp13.phx.gbl...
> hi all,
> I want to setup replication on Access Database.. I want data will be
updated
> in SQL Server from Access database..
> 1) Which replication type will be best suited (merge or transactional)
> 2) How I will setup subscription on Access database. Whenever I try to
> create a push subscription I only found option to create subsription on
SQL
> Server database. Although I have checked "Hetrogeneous datasources such as
> Access" option when creating publication.
> any suggesstion or link to article will be highly appreiciated..
> Thanks
> Ansari
>
>