Reopen DAO.db

[Jim Carlock]

I have some code that closed the global DAO.db object. I want to
reopen it after it's closed.

Is there a way to do this?

 

[Jim Carlock]

Something funny is going on. It's something else though. I can
close and reopen the global object with the following code...

'open it
Set db = DAO.OpenDatabase(kMDB_NAME)

'close it
db.Close

'reopen it
Set db = DAO.OpenDatabase(kMDB_NAME)

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


I have some code that closed the global DAO.db object. I want to
reopen it after it's closed.

Is there a way to do this?