More on "cannot open another database" error
- From: "Joanne" <enufsaid878@xxxxxxxxx>
- Date: 30 Jun 2006 11:38:28 -0700
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.
The user logs in, then goes to the Add Invoice form - it's a fairly
simple form, single table recordset with a subform based on a single
table. When the user starts to enter the information, the On Dirty
event opens a table to look for the last voucher number entered so it
can generate the next consecutive number. As soon as the On Dirty
event it triggered, she gets the Cannot Open Another Database error.
I even tried clearing any open db or rs when On Dirty is triggered
using
If Not rs Is Nothing Then
rs.Close
Set rs = Nothing
End If
If Not db Is Nothing Then
Set db = Nothing
End If
I'm lost on this problem. I don't know what else to try.
Thanks in advance for any help you can give!
.
- Follow-Ups:
- Re: More on "cannot open another database" error
- From: David W. Fenton
- Re: More on "cannot open another database" error
- From: ManningFan
- Re: More on "cannot open another database" error
- Prev by Date: Re: SYNC Form to listbox
- Next by Date: Newbie question on formatting a field in table design
- Previous by thread: Microsoft Forms 2.0 TextBox
- Next by thread: Re: More on "cannot open another database" error
- Index(es):
Relevant Pages
|
