How to point to a file on a server

  • Thread starter Thread starter albert.repasky
  • Start date Start date
A

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
 
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
 
Back
Top