Multiple User

[urs]

hi
i am about to start a project
under which i will have 1 server and 10 clients
my back end which access while be on the server
now i want all of them to access my back end at the same time. with different ID and password
all the clients will have different ID
can any one help me regarding this
thanx

[bhanuprakash]

u say that 10 clients will have differnet id then what is your back end if it is either oracle or sql server then you can create the user id in your back end then when the user logs on to ur application he has to provide that userid and pwd then you connect the database using that user id and password.so you should maintain same userid and pwd for both front end and back end.

to provide userid and pwd you have the facility while setting up the connect string.
if you like to have more info then let me know what backend your are using which utility ur using i mean dao,ado e.t.c

[berta]

I suggest U to have an ActiveX exe project with pool threads=1.



'-- activex --
'//bas module
'///basSever
public MyServer as new coServer
'///

'//class module
'////class factory (global multiuse)
public function GetServerObject(usr,pwd) as coServer
'if usr,pwr RIGHT then
set GetServerObject = myserver
'else
set GetServerObject =nothing
'end if
end function
'////

'//class module
'///Class coServer (public not multiuse)
'Code for Implentation of server
'////
'----

'-- client ---
'getsserver
dim m_server as coserver
set m_server=GetServerObject (user,pwd)
if m_server=nothing then msgbox "not connected"
-------------




hi,brt

<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/images/bertaplanet.gif'>
</center>

[urs]

yes i would like to know more about
i will b using Access 2000 and ado
i am not sure of connecting people may b i have to use winsock or something better if u can suggest
and i also wanted to know if i have to make any changes in the back end i mean some settings in the access i dont think more than i user can make changes on the same table at same time

[bhanuprakash]

if u r using access2000 as he back end then while using ado ther eis no rpoblem u use a common userid and pwd to connect to back end.when ever you are updating the database you can open the recordset by setting the cursor type as dynamic and lockoptimistic so it will allow only one user to update at a time.when you are just reaidng the information you can open the recordset in readonly format so many users can read at the same time.

[urs]

can u plzz link me to a project similar to mine