Object was opened

[ching0418]

hello guys,

do you have any idea why i receive this error message

Run-time error '-2147217915 (80040e05)':
Object was open

There are two cases in which this error is encountered:

1. A 'Low in Virtual Memory' error is encountered is encountered first, then the message stated above pops up; or
2. Two computers are running the program.

please help!

thanks in advance,
Cheryl

 

[CassandraR]

Hi Cheryl:

I have received this message whenever I try to open a database connection that was already open. Usually, the problem is that I forgot to close the database connection on a previous access to the database.

The best thing to do is to ensure that you close the connection after transferring data to/from the database. I use the following code:

    If m_cnnMyDB.State <> adStateClosed Then m_cnnMyDB.Close

The sloppy (bad) way is to get around the error on open is to

    If m_cnnMyDB.State <> adStateOpen Then m_cnnMyDB.Open

HTH,
Cassandra