Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Fri May 7 14:02:39 CDT 2004
Good point. Mark -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Friday, May 07, 2004 2:58 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Maintaining a persistent connection to the back end . When I create a 'link' form, I don't even bother with code (one of the few things I like doing without code). I just link a table, then create an autoform to that table. Then in my startup process, I open that form hidden. Linking done. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Friday, May 07, 2004 1:13 PM To: '[AccessD]' Subject: [AccessD] Maintaining a persistent connection to the back end. 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com