Prev: Append a current record in a subform to another table
Next: Migrating to 64 bit access db solution
From: Tony Toews [MVP] on 1 Feb 2010 22:09
Sanford <sfleming(a)gmail.com> wrote:

>I tried using a DAO database connection instead of bound forms, and am
>having the exact same performance issues.
>
>It seems that once Access closes an MDB/LDB connection that there are
>issues re-opening it in the same session.
>
>Anyone else want to weigh in ? Thanks

There shouldn't be any difference between using a bound form and a recordset or
database connection. And reopening the connection should work. Are you defining
the connection as a global variable in a module?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
First  |  Prev  | 
Pages: 1 2
Prev: Append a current record in a subform to another table
Next: Migrating to 64 bit access db solution