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

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 (AT) nospam (DOT) infovis.co.uk> wrote

Sorry I meant replication. Something that can update data in both directions
periodically, automatically if possible.

Thanks

Regards

"Mike C#" <xxx (AT) yyy (DOT) com> wrote

I don't personally know of any automated way to do that built into Access or
SQL. I can imagine a custom app to do it wouldn't be that difficult to
build though. Maybe someone else will respond with an answer closer to what
you are looking for. Sorry...

"John" <John (AT) nospam (DOT) infovis.co.uk> wrote

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 (AT) nospam (DOT) infovis.co.uk> wrote

Thanks I will check that. Any different in sql 2005?

Regards

"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> wrote

Now that's cool -- replication from SQL to Access. Although I'll never do
that personally, you just sold another copy of your book over here

"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> wrote

Its not supported in SQL 2005.

--
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 (AT) nospam (DOT) infovis.co.uk> wrote