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

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



More information about the AccessD mailing list