Prev: MAPI Issue
Next: Register a file extension
From: Helmut Meukel on 8 Apr 2010 15:52
>
> � Also, i read that in real-life, the Jet engine can supprot upto 10
> � concurrent connections. In case i will open the same local database
> � for read-only purpoeses by more than 10 connections concurrently
> � (invoke this vbs several times concurrently), will it stop working, or
> � will it work too slow?
>
> I wouldn't expect concurrency issues if the database is being opened read-only
> for this few
> connections.
>


The 10 concurrent connections ar no limitation of Jet, but of
the OS. Access/Jet MDBs are often used on workstation boxes and
only the Server versions of the OS have unlimited connections.

Helmut.

From: Helmut Meukel on 9 Apr 2010 04:07
"Helmut Meukel" <NoSpam(a)NoProvider.de> schrieb im Newsbeitrag
news:uFhCJU11KHA.3868(a)TK2MSFTNGP06.phx.gbl...
> >
>> � Also, i read that in real-life, the Jet engine can supprot upto 10
>> � concurrent connections. In case i will open the same local database
>> � for read-only purpoeses by more than 10 connections concurrently
>> � (invoke this vbs several times concurrently), will it stop working, or
>> � will it work too slow?
>>
>> I wouldn't expect concurrency issues if the database is being opened
>> read-only for this few
>> connections.
>>
>
>
> The 10 concurrent connections ar no limitation of Jet, but of
> the OS. Access/Jet MDBs are often used on workstation boxes and
> only the Server versions of the OS have unlimited connections.
>
> Helmut.


Just an addition:
AFAIK, the local session counts to the 10 connection limit.
OTOH, if User Abe on PC00017 uses more than one program to connect
to the MDB-PC, and/or multible db-connections within his program, it
still counts as one connection.
If a program opens a remote db a connection to this remote PC is created.
After some time of inactivity (can be changed by a registry entry) the
connection
is dropped and automagically re-established when the program again accesses
the db. So the program is unaware of this connection stuff handled by the OS
and runs on an error if the OS can't re-establish the connection due to
exceeding the 10 connection limit.
This causes really hard to trace errors.

Helmut.

First  |  Prev  | 
Pages: 1 2
Prev: MAPI Issue
Next: Register a file extension