Search results

In Access 2003, The fields are still populated after closing the connection. If I do leave the connection open, the forms do not unload and open fine because connection.close is never called. The problem with leaving the connection open is that it will stress the server, since many people will...

I have a form with multiple subforms. The ADO connection is opened to populate the fields in the form and subforms and closed afterwards so it does not slow down the servers. In Access 2003, it works fine, but 2007 causes all the subforms to unload when the connection tries to close. To close...