[AccessD] Recordset method Failed

[David Emerson]

Hi Stuart.

The programme works ok on the clients current server and on my development
one.  We are talking lots of recordsets (one form has approx 20) and they
are being closed as soon as they have been assigned to the forms/comboboxes.

The IT guy is building a clean server to test on so hopefully this will
solve the problem.

Regards

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Friday, 8 September 2017 10:44 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Recordset method Failed

Sounds like a problem with connection limits / concurrent commands.  How
many recordsets are you talking about  here?

Are you closing the recordsets after populating the comboboxes?

What connector are you using to the SQL Server, Native Client?

--
Stuart

On 7 Sep 2017 at 22:18, David Emerson wrote:

...
> The system was originally being tested in Access 2010 (it is currently 
> running successfully in Access 2010 on a different server).  Upgrading 
> Access to 2013 has partially solved the problem - some combo boxes and 
> forms are having their recordsets updated but not all of them when 
> there are a large number on a form, or the form has a large number of 
> subforms.
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com