I'm working with a small business that uses an Access-based database for work order mgmt. The system has been around for years and they have 6-7 PCs using custom software from an ISV to access the database. The database is accessed over a mapped drive (Z:) connection.
Several months ago they began getting this error intermittently:
Data source name not found and no default driver specified
This results in the ISV having to connect to the database and run a repair in order to recover the database. The error they see is a bit more specific and suggests that the file format is corrupt. The support tech suggests that the issue is caused by a transaction failing across the network. To that end we've tried several things
- moved the database to a different host in case the original "server" PC had issues
- replaced the network switch
- started taking the clients off the network one by one in an attempt to isolate the problem child with no consistent results
So far, no luck.
My question(s) - Could one of the PCs be closing its drive mapping and corrupting the open database - Is there anything new in Windows 7 that might be getting in the way - Can you recommend a better approach to isolating the cause.