[AccessD] Maintaining a persistent connection to the back end.

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Fri May 7 13:13:11 CDT 2004


Microsoft recommends this procedure.  Any common practices that deviate from
this method?

1. Create an empty form.  2. Declare a recordset variable in the global
declarations section.  3.In the OnOpen event, open a recordset against any
table.  4. In the OnClose event, which will activate when the MDB is closed,
close the recordset and set the variable to nothing.  5. Ensure that you
always open this form when opening the MDB. You will likely want to have
this form hidden when you open the file. 


Mark



More information about the AccessD mailing list