469,352 Members | 1,708 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,352 developers. It's quick & easy.

DAO OpenDatabase

Hi,

I'm opening a database using the following code:

Set m_dbDatabase = OpenDatabase("", False, False, strOdbc)

Works OK and connects to the database with no problem. If however
while I'm connected the connection is lost (i.e. the server goes down)
and I try to reconnect to the database using the above method I get
success even if the server is still down. But when I try and open a
recordet I get the error message "...closed/terminated".

It seems to me it is still using the previous connection, since the
OpenDatabase connection the second time around is instantaneous. I
have treied setting the database object, workspace object and even the
dbengine object to Nothing but has made no difference.

Has anyone any ideas why this is happening and how I can re-establish
a connection to the server?

Any help would be greatly appreciated.

Regards

Simon
Jul 17 '05 #1
0 9256

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by kids_pro | last post: by
1 post views Thread by Henry Stockbridge | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.