Access MDB on a network is erratic

[janefield2002]

Hi there,

I get the following error using Access ODBC drivers:

'(unknown)' is not a valid path. make sure that the path name is
spelled correctly and you are connected to the server on which the
file resides access network

My setup
-------------
- 3 PCs connected as peers in a network (just a workgroup)
- 1 NAS (Network storage is ReadyNAS) on the same network
- All 3 PCs can "see the" NAS. So, I just type the IP of the NAS in
explorer and the contents of the NAS pop up.
- Each PC has some code that tries to "read" from the MDB on the NAS.

Sometimes, the code can connect and read from the database. Sometimes
it can't. The problem is erratic, which makes debugging it very hard.

My investigation so far:
----------------------------------
- I'm biased towards thinking that it has something to do with
threading. i.e.
Is it possible that 3 computers cant do a "read" on the mdb at the
same time?
- I dont think it is a "security" problem because IIS is not in the
equation and all the PCs can see each other and the NAS as well...

Please advise!

Thanks!