Re: 3014, 3581 Errors: Cannot open any more tables, A2002

From: Michael \(michka\) Kaplan [MS] (michkap_at_online.microsoft.com)
Date: 02/21/04 

Date: Sat, 21 Feb 2004 11:44:11 -0800

The error is causd due to an excessive number of table object references
(actually cursors to tables) being opened. It is not (usually) due purely to
the DAO/ADO objects you open but instead to the items opened behind the
scenes by Access for forms/reports and their constituent databound controls.
The number of cursors that have to be opened is significantly increased when
you use replication due to the constant need of Jet to reference/update
replication system tables.

The limit in Jet <= 3.5 was 1024 (increased to 2048 in a service pack). The
limit in Jet 4.0 is 2048.

The way around the issue is to simplify forms and reports so as not to hit
the problem. 

-- 
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"David" <deaton@nospamever.dsnonline.org> wrote in message
news:9zKYb.19836$_66.17508@twister.rdc-kc.rr.com...
> Since converting our tables-only backend to a replicated database, (the
> front end is not replicated) we're getting lots of 3014 and 3581 errors:
> Cannot open any more tables, when using the front ends. The only changes
to
> the front ends were the table links. Recordsets are explicitly closed in
all
> procedures. Couldn't find any help on the KB. Any ideas? Thanks in advance
> for any help you can provide!
> David
>
>
Loading