sql server replication: Replication concept -- sql server replication

Replication concept

Jack
6/12/2007 9:32:01 AM

sql server replication:

Hi,
I got a new application with Access front end and sql server back-end. This
application has replication features where users can directly upload their
changes on the main server. I have no knowledge about replication. However, I
need to maintain this sytem. Is there any article or book that will help me
achieve this? Please let me know. Thanks in advance.

RE: Replication concept

Paul Ibison
6/12/2007 9:40:01 AM

Are you sure that this is being replicated? If users are sending their access
changes to sql server, it sounds like this might be the way that the Access
application is designed, and not SQL Server replication. If it is somehow SQL
Server Replication, then there are 2 books out there (see
www.replicationanswers.com for links on homepage) and books on line (BOL).
Cheers,
Paul Ibison

RE: Replication concept

Jack
6/12/2007 9:59:03 AM

Thanks Paul for your advise. I appreciate it.
Best Regards,

[quoted text, click to view]

RE: Replication concept

Paul Ibison
6/12/2007 10:29:01 AM

Hope the books help, but I'd check first of all verify that you do have
replication occurring. It's possible that heterogenous subscribers have been
configured so your Access database is a subscriber to a SQL Server publisher,
and the uploading of changes in Access is a triggering of the synchronization
process (starting the ActiveX control to merge a pull subscription). Having a
look at the SQL Server box should show if this is the case and if so, looking
for heterogenous subscribers in BOL should help.
Paul Ibison

Re: Replication concept

Hilary Cotter
6/12/2007 5:19:13 PM

I would check to see if they have linked tables or if they have code in the
access project to write to SQL Server.

--
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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.