"John" <John@nospam.infovis.co.uk> wrote in message
news:%23kG4E4HfGHA.4976@TK2MSFTNGP02.phx.gbl...
> Hi
>
> Is it possible to reliably sync an access db with its equivalent sql
> server db using the built-in facilities of sql server and access?
>
> Thanks
>
> Regards
>
>

"John" <John@nospam.infovis.co.uk> wrote in message
news:e3XyRCIfGHA.1276@TK2MSFTNGP03.phx.gbl...
> Sorry I meant replication. Something that can update data in both
> directions periodically, automatically if possible.
>
> Thanks
>
> Regards
>
> "Mike C#" <xxx@yyy.com> wrote in message
> news:dkQbg.1433$%02.172@fe09.lga...
>> What do you mean by sync? You can use linked tables in Access and create
>> some sort of script to copy data. You can also set up a DTS package (SQL
>> 2000) to export data to an MDB file and schedule it.
>>
>> "John" <John@nospam.infovis.co.uk> wrote in message
>> news:%23kG4E4HfGHA.4976@TK2MSFTNGP02.phx.gbl...
>>> Hi
>>>
>>> Is it possible to reliably sync an access db with its equivalent sql
>>> server db using the built-in facilities of sql server and access?
>>>
>>> Thanks
>>>
>>> Regards
>>>
>>>
>>
>>
>
>

"John" <John@nospam.infovis.co.uk> wrote in message
news:%23kG4E4HfGHA.4976@TK2MSFTNGP02.phx.gbl...
> Hi
>
> Is it possible to reliably sync an access db with its equivalent sql
> server db using the built-in facilities of sql server and access?
>
> Thanks
>
> Regards
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23wyqxHMfGHA.1264@TK2MSFTNGP05.phx.gbl...
> In SQL 2000 you can replication to access using transactional or merge
> replication. Follow the instructions on how to set this up in the link to
> my book in the sig. The instructions are in the sample chapter.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:%23kG4E4HfGHA.4976@TK2MSFTNGP02.phx.gbl...
>> Hi
>>
>> Is it possible to reliably sync an access db with its equivalent sql
>> server db using the built-in facilities of sql server and access?
>>
>> Thanks
>>
>> Regards
>>
>>
>
>

"Mike C#" <xxx@yyy.com> wrote in message news:dkQbg.1433$%02.172@fe09.lga...
> What do you mean by sync? You can use linked tables in Access and create
> some sort of script to copy data. You can also set up a DTS package (SQL
> 2000) to export data to an MDB file and schedule it.
>
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:%23kG4E4HfGHA.4976@TK2MSFTNGP02.phx.gbl...
>> Hi
>>
>> Is it possible to reliably sync an access db with its equivalent sql
>> server db using the built-in facilities of sql server and access?
>>
>> Thanks
>>
>> Regards
>>
>>
>
>