DWUTKA at marlow.com
DWUTKA at marlow.com
Fri May 7 13:58:12 CDT 2004
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