T
TESA0_4
Hi, I have just been reading http://support.microsoft.com/kb/303528/EN-US/#15
that talks about how to maintain the performance of a Jet DB. One of the
recommendations is to 'Minimise the number of connections that are made from
each client'. It goes on to recommend that 'you design each client to use one
connection to a MS Jet DB'. However, the article does not provide any 'how to
advice'.
Obviously, I do not understand what a 'connection' is or how to design my
client to use only 'one connection'.
I have developed my application with a BE and individual copies of the FE on
each users' PC and I have a hidden form reading a data record from the BE so
that each user maintains a persistent connection with the BE.
Can someone explain how I can ascertain whether the client I have created is
creating one or more connections to the DB and if it is creating more than
one connection, what do I have to do to avoid the additional connections?
Thanks for any advice or enlightenment you can provide.
that talks about how to maintain the performance of a Jet DB. One of the
recommendations is to 'Minimise the number of connections that are made from
each client'. It goes on to recommend that 'you design each client to use one
connection to a MS Jet DB'. However, the article does not provide any 'how to
advice'.
Obviously, I do not understand what a 'connection' is or how to design my
client to use only 'one connection'.
I have developed my application with a BE and individual copies of the FE on
each users' PC and I have a hidden form reading a data record from the BE so
that each user maintains a persistent connection with the BE.
Can someone explain how I can ascertain whether the client I have created is
creating one or more connections to the DB and if it is creating more than
one connection, what do I have to do to avoid the additional connections?
Thanks for any advice or enlightenment you can provide.