Re: 3014, 3581 Errors: Cannot open any more tables, A2002
From: David (deaton_at_nospamever.dsnonline.org)
Date: 02/23/04
- Next message: mbennetts: "One Way Indirect Replication"
- Previous message: David: "Synchronizer Only Starts When Logged On to Server"
- In reply to: Michael \(michka\) Kaplan [MS]: "Re: 3014, 3581 Errors: Cannot open any more tables, A2002"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Feb 2004 16:48:56 GMT
It seems hard to believe that any of our forms or reports would open that
many tables! But I'll have a close look at them all.
Thanks very much for helping,
David
"Michael (michka) Kaplan [MS]" <michkap@online.microsoft.com> wrote in
message news:em4vUML%23DHA.1392@tk2msftngp13.phx.gbl...
> 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
> >
> >
>
>
- Next message: mbennetts: "One Way Indirect Replication"
- Previous message: David: "Synchronizer Only Starts When Logged On to Server"
- In reply to: Michael \(michka\) Kaplan [MS]: "Re: 3014, 3581 Errors: Cannot open any more tables, A2002"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
