I was selected to be a guest blogger on the official Microsoft Access blog! You can read the article here:


SQL Server Hosting

Please read and come back here for some final thoughts on the technique.

Another alternative: DAO

When I wrote the guest post I automatically selected ADODB since that’s what I use almost always in my code. Here’s the same concept using DAO:


Persistent Recordset

If you find yourself constantly opening and closing the recordset, you can choose to create a module level variable, move out the line 30-32 into form’s load or current event and not closing the recordset by commenting out line 160 above.  If you do go down this route then you would need to retrieve all related records in one trip. You also may want to open the recordset as a snapshot-type recordset to ensure the request is pulled only once. If it’s a lot of records in memory it may not be worth it.

After all these years I’m continually amazed at the capabilities of Access and how we can stretch the envelope of what can be done.