Erratic access of MDB over network

J

janefield2002

Hi there,

I get the following error using Access ODBC drivers:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.

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