Click here to Skip to main content
11,416,787 members (68,303 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: VB.NET
I'm working to VB.Net Desktop application
The same application will be installed on two or three PC ; and each version had different privileges and one of those had the administration privileges.
and they share the same database (any update will be appear to other users).
How I can Do that logically ? and what I need ?
Posted 25-Sep-12 3:29am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You need no more that being able connect remotely to the central database (since you may use the database as communication, sinchronization mean for the applications).
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

1. share your database on LAN/WAN
2. set new connection string in exe/text file [where sql connection string is written]

step 1: follow steps given in this link [For access sql database remotely(from different pcs)][^]

step 2: after step 1 complete then change connection string's parameters,
datasource = server-name OR IP-Address [which is in sharing now after step 1] ;
Initial catalog = your database name ;
UserId = sql server - user login Id ;
Password = sql server - user login password;

Happy Coding!
Smile | :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 9,270
1 OriginalGriff 7,512
2 Maciej Los 3,710
3 Abhinav S 3,324
4 Peter Leow 3,084

Advertise | Privacy | Mobile
Web04 | 2.8.150427.4 | Last Updated 25 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100