Must I Reconnect??
Aug 24, 2004i will like to ask when i have added a extra table in the database using microsoft access,
do i still have to reconnect it to the ODBC data source again??
Hope someone can reply asap. Thank you!!
ADVERTISEMENT
Modules & VBA :: Network Crash - Any Way To Reconnect Objects Without Closing And Reopening Database
Oct 23, 2013I 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?