View Single Post
  #5  
Old April 19th, 2010, 07:50 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default GetOpenFile() and UNC path

"Nick Del Vecchio" wrote in message
...

I have the database on a computer with Windows XP SP3 using Access 2002.
The database and image files are in that computer's local folder which has
been shared on the network. When I browse to the image from that computer
using My Network places, Access changes the path to the local folder after
I select the photo. However, if I launch the same database from a
networked computer that

uses Windows XP and Access 2003, the text box keeps the UNC path after I
select the photo.

If I use the local computer to access the same file with the UNC path to
the picture that was created by a networked computer - there is no
problem. The picture is displayed. This works well for all networked
computers as well.

However, if I use a networked computer to view the picture that was
inserted by the local computer, the path is to that computer's local drive
and I get an error that states that the path is not valid. For some
reason, the local computer with Access 2002 is changing the path to it's
local drive instead of maintaining the UNC path.


I can't seem to reproduce that on my PC running Vista, but I may not have
set up the exact same circumstances. I don't think it's Ken Getz's code, as
I'm using that code myself. I suspect it's an OS thing. I don't have any
good suggestion, though, except to either type in the UNC path directly (if
that works), or do it on a networked PC instead of the one where the file is
local.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)