Thanks for the input.
I've gone through all of the VB code and wherever there's a Recordset.Open, I've ensured that there's a Recordset.Close.
Any other suggestions?