Access MDB on a network is erratic

J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top