Can't open MS Access Files from UNC path

  • Thread starter Thread starter Kishore Ramakrishnan
  • Start date Start date
K

Kishore Ramakrishnan

Hi All,

I am facing a problem with MS Access 2003 files. I have a few MDB files,
which are kept in one server, and I want to open these from another machine
through UNC Paths, like \\MyServer\MyShare\MyFile.mdb. I have read/write
permission on this share. Still when I open this mdb from another server (or
even from this server, through UNC Path) I am getting an error "Windows
cannot access the specified device, path or file. You may not have the
appropriate permissions to access the file". I can go to the local folder and
open these files. I can open, create or edit other files in this share. So I
think this problem is related to MS Access Files only. Creating a mapped
drive to this server is out of question for me, due to our security policy.
Could any one help me, please?

Thanks,

Kishore
 
A mapped drive doesn't change security.

Some of this really depends on which _ZONE_ you have this database
in. Add the share as a trusted site in IE and see if this helps.

But the bottom line is that access requires security in 2-3 different
places... and it's still not as secure as SQL Server.

-Aaron
 
You might want to check whether or not that server has a DNS entry. You
might also try entering the IP address for that server in your Hosts file:

C:\WINDOWS\system32\drivers\etc\hosts

More than likely though, it is a permissions problem that your admins
created either intentionally, or accidently when they created the security
policy. To find out for sure, create a dummy app with a button in it to open
an Excel file using the UNC path.
 
I can go to the local folder and
open these files. I can open, create or edit other files in this
share.
 
wow that is great.

What is the path if he is on WIndws 9x?

Wouldn't you just try to 'ping servername' instead of having this kid
screw with DNS?

-Aaron
 
Back
Top