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
