Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Design decision to replicate or not using Sql Server Replication

Status
Not open for further replies.
cmmrfrds

cmmrfrds

Programmer
Feb 13, 2000
4,690
US
My application, which is being developed in Access will have all remote users. In some cases the remote users cannot be connected to the Sql Server database. I was thinking of keeping some duplicate tables on each PC and manually uploading and downloading inserts and updates. I prefer to have this automated. Will Sql Server Replication work?? What are the pitfalls?? I am planning on making the Access project an .adp and using ADODB to connect to the Sql Server database. Is this okay and will it work with replication?

Thank you for any help.
Jerry
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
526
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
821
Volvere
V
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
724
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
637
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top