How to point to a file on a server

[albert.repasky]

I am setting up some importing and exporting of to and from the DB. It
is now on a server so that everyone can get at it. I set up some
TransferSpeadsheet to do this. The problem is that when the users map
a file to the server, I do not know which letter of the alphabet they
will use. So I thought I could use the universal naming convention to
point at the folder on the server. It worked when I am on testing
server and pointing to the production server. Now when I run on the
production server and pointing to itself, it does not work.

Here is the string for the file:
\\W2kdata1552\mgsdept\ExportOpenUS.xls

The error is:

That it cannot open the file. It is already open exclusively by
another user, or you need permission to view its data.

Thanks for the help.

Arep

 

[Jeff Boyce]

If this were mine, I'd next check to see if I could get it to point to a
file on my local PC. ?Perhaps there's an issue with referring to a network
file?

Regards

Jeff Boyce
Microsoft Office/Access MVP