best ways for multi-user application
-
please let me know best ways for multi-user application, in simple way, we shared a folder on server pc and link to it in application, but in this case, all clients could visit files and copy them!
hamid_m wrote:
please let me know best ways for multi-user application
That's kind of vague, don't you think? Do you want multiple people running the app from the same network share, or do you want multiple people running your app hitting the same database? SQL Server or Access?
hamid_m wrote:
we shared a folder on server pc and link to it in application, but in this case, all clients could visit files and copy them!
Of course, that's what a file share is for!
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
hamid_m wrote:
please let me know best ways for multi-user application
That's kind of vague, don't you think? Do you want multiple people running the app from the same network share, or do you want multiple people running your app hitting the same database? SQL Server or Access?
hamid_m wrote:
we shared a folder on server pc and link to it in application, but in this case, all clients could visit files and copy them!
Of course, that's what a file share is for!
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007multiple people running app from their pc that linked to network and work with one database in server shared folder. not important sql server or access, i mean how can i do this without get folder access to clients, i dont want client visit files and shared folder
-
multiple people running app from their pc that linked to network and work with one database in server shared folder. not important sql server or access, i mean how can i do this without get folder access to clients, i dont want client visit files and shared folder
hamid_m wrote:
work with one database in server shared folder
This means that you'd be using an Access database, which is file based. You have absolutely no choice but to put the .MDB file in a network shared folder, and giving the users Read and Write permissions to the share and the folder. No choice what-so-ever. The only way to do it so you don't need a share is to use a REAL database engine that works on TCP/IP, like SQL Server or MySQL.
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
hamid_m wrote:
work with one database in server shared folder
This means that you'd be using an Access database, which is file based. You have absolutely no choice but to put the .MDB file in a network shared folder, and giving the users Read and Write permissions to the share and the folder. No choice what-so-ever. The only way to do it so you don't need a share is to use a REAL database engine that works on TCP/IP, like SQL Server or MySQL.
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
Dave Kreskowiak wrote:
The only way to do it so you don't need a share is to use a REAL database engine that works on TCP/IP, like SQL Server or MySQL.
would you please help me to check sql server by tcp/ip connection?
What do you mean by "check sql server"??
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
What do you mean by "check sql server"??
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
i mean create and check what you say about TCP/IP connection by sql server. is there any tutorial or sample for it? thanks
All you have to do is look in the documentation for the System.Data.SqlClient namespace. There's tons of examples. The only thing missing from them is a connection string, which will be specific to your environment. You can find examples of those at ConnectionString.com[^].
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007