Check connections with DAO????

[Dan]

Is there any way to check LAN connections with DAO?

My network will hang when the file/print cluster moves
between servers ... and this makes my DB crash.... and
then I have kick everyone out to repair/compact.

Is there a way to check to see if the DB is still
connected before it tries to communicate over the LAN?

Would this even help or is the LAN hanging always going to
crash the DB?

I have not split the DB yet.

If I split the DB and refresh the linked tables before a
transaction is performed would this help?

This newsgroup is always helpful.

Thanks a bunch!

Dan

[Tim Ferguson]

"Dan" <stock...@msn.com> wrote in
news:38d801c471eb$08e7aab0$a501...@phx.gbl:

>
> Is there a way to check to see if the DB is still
> connected before it tries to communicate over the LAN?
>
> Would this even help or is the LAN hanging always going to
> crash the DB?
>
>

In a word: yes. Access-Jet has always been sensitive to even minor
hiccoughs on a network, down to a misbehaving NIC not even involved in the
particular connection.

If you have a noisy network that you cannot fix, you might be well advised
to look at the SQL Server/ MSDE options which will make your database much
more error-resistant.

Hope that helps

Tim F