The database I've been asking all the questions about is now ready to be deployed. Unfortunately, the share drive method to allow the 10-12 users to get to it has a wrinkle. We have split offices - one in the center of the country and one in the east. If running on a file server in center, east runs STUPID slow; reverse happens if placed on server in the East.
We are using Microsoft Access 2007. I have confirmed that we have no firewall between the 2 offices and a humongous pipeline only about 30% consumed. Running a sniffer trace while one east user and one central user produced these 3 errors on the user in the OTHER office from server location:
NT Status: STATUS_OBJECT_NAME_NOT_FOUND (0xc0000034)
NT Status: STATUS_MORE_PROCESSING_REQUIRED (0xc0000016)
NT Status: STATUS_NO_SUCH_DEVICE (0xc000000e)
The users in the location where the server resides have little to no lag and no "bomb-out" problems.
Any tactics anyone would like to suggest?