Re-establish Database after Network Crash

[AccessNub]

Hi all,

I have a database that runs a macro/report every 2 hours, however our network has been up and down lately. This causes the macro to fail when trying to log into the system because the table that is storing your username is no longer in the database. When I check, all tables, linked tables, forms, reports, macros and modules are all gone. I find the only way to get them back is to close the database and reopen.

What I want is a way to reconnect the objects without closing and reopening.

Is there a way to do this?

 

[Rx_]

I vaguely remembered (something common for me) a link about this.
http://www.access-programmers.co.uk/forums/showthread.php?t=237710&highlight=DSNless
It is a function that checks for connection before a report or query is run.

Basically build a delay to try later if there is no connection?
http://www.access-programmers.co.uk/forums/showthread.php?t=217498&highlight=DSNless
or DSNLess or DSN_Less or DSN-LESS (use the search engine on this site)

Possibly create code (there is plenty to copy) that if there is no connection, rebuild all the linked tables and refresh the table objects. Then try the query again?