Can't open MS Access Files from UNC path

[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

 

[aaron.kempf]

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

 

[Arvin Meyer [MVP]]

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.

 

[aaron.kempf]

I can go to the local folder and
open these files. I can open, create or edit other files in this
share.

 

[aaron.kempf]

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