split database network connections

[Poohbear0471]

I hope everyone is doing well and staying safe!



We're currently working remotely. The backend to my database is on a network drive. As this is a new situation to us, our network drives are not 100% stable yet. We will lose our network connection for a few seconds a couple times a day. Is there any kind of code I can put into my frontends to reconnect to the backend when this happens so my team doesn't need to close and re-open the database?

Thank you!
Ed

[ranman256]

1. if the tables are connected to the FE via odbc connection, they would just resume when the connection rejoins.
2. if you have the tables connected via vb code, then you would need to re-run the connection code.

option 1 would be better.