Persistant Connection to a Table in BE

[Guest]

Hi-

Now that I've split my DB (thanks to all who commented), I want to keep a
persistant connection open to a small table while the database remains open.
I've read somewhere that this can greatly improve database functionality over
the network.

I (apparently) can't find the code to do this, which I had found and
(stupidly) not bookmarked. Can someone point me to a sample, or does someone
have their own "home grown" method that is simple, elegant and functional?

Regards,
-David

 

[Jeff Boyce]

David

Tony's website has info about creating a persistant connection to improve a
performance problem:

http://www.granite.ab.ca/access/performanceldblocking.htm

Regards

Jeff Boyce
<Access MVP>