Re: More on "cannot open another database" error
- From: "David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx>
- Date: Fri, 30 Jun 2006 15:50:54 -0500
"Joanne" <enufsaid878@xxxxxxxxx> wrote in
news:1151692708.069851.53040@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:
I have searched through previous threads regarding this error. I
went back through all my code to make sure I closed and set to
nothing all open db's and rs's. However, I still have one
computer getting this error. This problem does not occur with any
other users - some of whom use the database continuously.
You don't say what version of Access is involved. If it were Access
97 (which is unlikely, I assume), it could be as simple as all the
machines except the problematic one having SR2 installed (or maybe
it was SR1) -- that service released doubled the number of table
handles from 1024 to 2048.
Given that it works OK on other machines, I'd guess the problem is a
software versioning problem. Check that the same versions of Jet and
Access are installed on all the machines.
And keep in mind that it's not merely a matter of DAO databases and
recordsets, but of *all* recordsets, including those open in forms,
subforms, combo boxes and listboxes. And that the table handles get
used up very quickly (a query with one source table uses up two
table handles, one for the source table, one for the query itself).
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.
- References:
- More on "cannot open another database" error
- From: Joanne
- More on "cannot open another database" error
- Prev by Date: Re: SYNC Form to listbox
- Previous by thread: Re: More on "cannot open another database" error
- Next by thread: Newbie question on formatting a field in table design
- Index(es):
Relevant Pages
|
|
