[AccessD] Error 3048 Cannot open any more databases

You tell it to disconnect after you fill the recordset.  Then you work
with the disconnected recordset until you are ready to throw it away or
reconnect and write it back to the table.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Wednesday, March 05, 2008 5:00 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 3048 Cannot open any more databases

Well, I never knew that.  Learn something every day.

Do you have to tell ADO to disconnect or does it do it automatically.
If auto, then do you assume it is closed in all cases and re-open it to
do something with it or do you test it (somehow) to see if it is
disconnected?

Thanks
Max