Check connections with DAO????

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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?
Click to expand...

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
 
Back
Top