View Single Post
  #14  
Old April 9th, 2007, 01:43 AM posted to microsoft.public.access
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Persistanct connections

"Albert D. Kallal" wrote in
:

However, as a general rule, I always do create a persistent
connection, as on some networks..it don't make a difference, but
on others...it makes a HUGE difference.


Has anyone tested the difference between opening a recordset on a
local linked table and simply initializing a db variable pointing to
the back-end database? Both create the MDB, but it seems to me that
the latter is more efficient.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/