Hi FogCity:

Just on first look, I would bet that it's probably your LAN and/or the Windows OSs. It should be an easy fix.

It could be the hub and an incompatability with Windows Vista. If you check http://forums.linksys.com/linksys/board/message?board.id=Hubs&message.id=180 you'll read a story how Windows Vista is incompatible with certain hubs, causing degredation in performance when connected (in that case the guy was using 2 XP machines and 1 Vista machine). In fact, Linksys had to take all their hubs off the "supported under Vista" list at that time (10/2007) according to the author. Imagine the scenario where the Windows Vista machine's MS Access front-end is bringing up a 20000 record table, then suddenly the hub performance degrades, then gets overwhelmed, breaking the connection. Bingo- "the freeze".

Also, you NEVER want to have a MS Access application on a more advanced Windows OS platform on a LAN accessing data from a backend MS Access application sitting on older version Windows OS platform. I did this back in 1999 with Window 2000 computers accessing a Windows ME computer and it corrupted my MS Access tables big time with occasional, but annoying once-a-week lockups. The poor LAN connection bug was never acknowledged anywhere by Microsoft, but once corrected (by getting the Windows ME off the LAN altogether), it never recurred.

FIX: You might wish to disconnect the Vista machine to make sure that it is not the culprit. If it is, either go all-XP or switch everything to Vista and be sure that you have a Vista compatible hub.

BTW, CNET UK placed Vista as one of Top ten terrible tech products last year... http://hubpages.com/hub/Cnet-Vista-one-of-Top-ten-terrible-tech-products

Good luck!
Al

Last edited by alborg; 02/21/2008 3:23 AM.