Which type of connection to be used in multi-ser environment?

Hi all,
I have a desktop application which has MS-Access as the DataBase.
In our current application we were maintaining persistent connection to
the DB.
Now, we are planning to upgrade the application to multi-user
environment. I want some suggestions if I can maintain persistent
connection for each user. I want know if it will effect the performance
or any network problems or any other problems. The application can have
approximately 5 users. I want to know which type of connection is best.
Connecting to DB when itz required or maintaining persistent
connection.
Any suggestions are welcome.
Thanks,
Swapna.
.

Relevant Pages

  • Re: Which type of connection to be used in multi-ser environment?
    ... Scaling a JET database with an Access application to 5 users is entirely ... file IO is transmitted over the network so if your design pulls down large ... Leaving the connection open is fine ... > In our current application we were maintaining persistent connection to ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: Communicating over the internet
    ... > That way you provide one manner in which to open the database, ... > can keep the connection open and then when someone wants to ... > server as the database and the soap dll connecting with a TCP socket. ... The name of the running program might help. ...
    (microsoft.public.vb.general.discussion)