Can't Open Anymore Databases

[Steve]

Access97 Database

The database is split into a frontend and backend and not connected to any other
database. The database has an unbound report with 15 subreports. Some of the
subreports include Excel charts in unbound object frames. When I add 3
additional subreports, I get the error message that Access can't open any more
databases. Can anyone suggest what may be causing the error message.

Thanks!

Steve

[Lyle Fairfield]

"Steve" <sp**@nospam.sp am> wrote in
news:25******** *********@newsr ead1.news.atl.e arthlink.net:

Access97 Database

The database is split into a frontend and backend and not connected to
any other database. The database has an unbound report with 15
subreports. Some of the subreports include Excel charts in unbound
object frames. When I add 3 additional subreports, I get the error
message that Access can't open any more databases. Can anyone suggest
what may be causing the error message.

Too many databases are open.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[PC Datasheet]

There are only two databases open - the frontend and the backend.
"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.17...

"Steve" <sp**@nospam.sp am> wrote in
news:25******** *********@newsr ead1.news.atl.e arthlink.net:

Access97 Database

The database is split into a frontend and backend and not connected to
any other database. The database has an unbound report with 15
subreports. Some of the subreports include Excel charts in unbound
object frames. When I add 3 additional subreports, I get the error
message that Access can't open any more databases. Can anyone suggest
what may be causing the error message.

Too many databases are open.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Lyle Fairfield]

"PC Datasheet" <sp**@nospam.sp am> wrote in news:fF4Xb.3783 $hm4.3324
@newsread3.news .atl.earthlink. net:

There are only two databases open - the frontend and the backend.
Uh Huh!
"Lyle Fairfield" <Mi************ @Invalid.Com> wrote in message
news:Xn******** ***********@130 .133.1.17...

"Steve" <sp**@nospam.sp am> wrote in
news:25******** *********@newsr ead1.news.atl.e arthlink.net:

> Access97 Database
>
> The database is split into a frontend and backend and not connected to
> any other database. The database has an unbound report with 15
> subreports. Some of the subreports include Excel charts in unbound
> object frames. When I add 3 additional subreports, I get the error
> message that Access can't open any more databases. Can anyone suggest
> what may be causing the error message.

Too many databases are open.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[David W. Fenton]

Lyle Fairfield <Mi************ @Invalid.Com> wrote in
news:Xn******** ***********@130 .133.1.17:

"Steve" <sp**@nospam.sp am> wrote in
news:25******** *********@newsr ead1.news.atl.e arthlink.net:

Access97 Database

The database is split into a frontend and backend and not
connected to any other database. The database has an unbound
report with 15 subreports. Some of the subreports include Excel
charts in unbound object frames. When I add 3 additional
subreports, I get the error message that Access can't open any
more databases. Can anyone suggest what may be causing the error
message.

Too many databases are open.

On the contrary, this error message can pop up when you've exceeded
the number of available table handles.

It doesn't necessarily have anything to do with what it claims.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[PC Datasheet]

Thanks, David,

What do you mean by "table handles"?

Steve
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@24. 168.128.90...

Lyle Fairfield <Mi************ @Invalid.Com> wrote in
news:Xn******** ***********@130 .133.1.17:

"Steve" <sp**@nospam.sp am> wrote in
news:25******** *********@newsr ead1.news.atl.e arthlink.net:

Access97 Database

The database is split into a frontend and backend and not
connected to any other database. The database has an unbound
report with 15 subreports. Some of the subreports include Excel
charts in unbound object frames. When I add 3 additional
subreports, I get the error message that Access can't open any
more databases. Can anyone suggest what may be causing the error
message.

Too many databases are open.

On the contrary, this error message can pop up when you've exceeded
the number of available table handles.

It doesn't necessarily have anything to do with what it claims.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Brendan Reynolds]

While the error message is not the most explanatory in the world - what it
means by 'database' is not necessarily what you and I would understand by
the word - it basically means you're trying to do too many things at one
time. You need to simplify that report - perhaps you can split it into two
reports, and print them one after the other?

--
Brendan Reynolds

"Steve" <sp**@nospam.sp am> wrote in message
news:25******** *********@newsr ead1.news.atl.e arthlink.net...

Access97 Database

The database is split into a frontend and backend and not connected to any other database. The database has an unbound report with 15 subreports. Some of the subreports include Excel charts in unbound object frames. When I add 3
additional subreports, I get the error message that Access can't open any more databases. Can anyone suggest what may be causing the error message.

Thanks!

Steve

[David W. Fenton]

"PC Datasheet" <sp**@nospam.sp am> wrote in
news:X2******** *********@newsr ead3.news.atl.e arthlink.net:

What do you mean by "table handles"?

See:

http://groups.google.com/groups?selm...aynet%4024.168
..128.86

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[PC Datasheet]

Thanks, Brendan!

Yes, it is a very complex report and I may need to resort to your suggestion!

Steve
"Brendan Reynolds" <br******@remov ethisindigo.ie> wrote in message
news:H7******** *********@news. indigo.ie...

While the error message is not the most explanatory in the world - what it
means by 'database' is not necessarily what you and I would understand by
the word - it basically means you're trying to do too many things at one
time. You need to simplify that report - perhaps you can split it into two
reports, and print them one after the other?

--
Brendan Reynolds

"Steve" <sp**@nospam.sp am> wrote in message
news:25******** *********@newsr ead1.news.atl.e arthlink.net...

Access97 Database

The database is split into a frontend and backend and not connected to any

other

database. The database has an unbound report with 15 subreports. Some of

the

subreports include Excel charts in unbound object frames. When I add 3
additional subreports, I get the error message that Access can't open any

more

databases. Can anyone suggest what may be causing the error message.

Thanks!

Steve

[PC Datasheet]

David,

I read the thread you reference and have a good idea now on how to count "table
handles". But still what specifically is a "table handle"?

Thanks!

Steve
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@24. 168.128.90...

"PC Datasheet" <sp**@nospam.sp am> wrote in
news:X2******** *********@newsr ead3.news.atl.e arthlink.net:

What do you mean by "table handles"?

See:

http://groups.google.com/groups?selm...aynet%4024.168
.128.86

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc