unc on windows terminal server

[patti]

My db is on server "a".

The batch file i use to call import macros (which call vba mods) has been
loaded onto a wts which has access installed. The wts isn't configured to
handle unc.

The batch file resides on the wts so that it can be run independent of an
individual's pc. The db calls on many files on many different servers.

I will be talking w/ it guy - but would like to better informed on the
subject of unc & mapped drives w/ access & wts. In particular, what is the
security issue of unc w/ wts? Any help, links, examples, experiences greatly
appreciated. I will also post this on wts newsgroup.

thanks,

patti

 

[SteveM]

Some people will argue the benefits of using UNC over mapped drives but there
really is no significant difference or benefit IMHO.

Steve

 

[patti]

Thanks for the response.

The problem is wts can't run my vba-based macros b/c it doesn't handle unc.
Sample code from the db:

FileCopy "\\W2k-nfs\DATA\\cat.txt", "\\W2k-fs\DATA\cat_" &
Format(reportdate, "mmddyyyy") & ".txt"
DoCmd.TransferText acImportDelim, "specImportCat", "ImportCat",
"\\W2k-nfs\DATA\cat_" & Format(reportdate, "mmddyyyy") & ".txt", False

any thoughts on how to get this to work? I'm not clear about unc or mapped
drives.

 

[SteveM]

Speak to your network admin and see if you can obtain a mapped drive letter
so you could change your code to:

FileCopy "F:\DATA\\cat.txt", "F:\DATA\cat_" & Format(reportdate, "mmddyyyy")
& ".txt"

....and so on.

Where is are your macros running from?
Are you remoting into a server with wts?

If the macros are running from the server and your DATA folder is off the
root C: folder of the server then just use C: instead of W2k-nfs.

Steve

 

[Tony Toews [MVP]]

The wts isn't configured to handle unc.

This is news to me. I wonder if the user profile you are logging onto
the Windows Terminal Server system does not have access to those
servers and/or folders. You should be able to navigate via Windows
Explorer >> My Network Places to see those.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[patti]

Thanks for the responses.

I will bring up the permissions w/ the network admin.

Another issue: I want the scheduled task to launch the batch independent of
any user being logged on. Is there a "master user" on wts?

 

[Tony Toews [MVP]]

Thanks for the responses.

I will bring up the permissions w/ the network admin.

Another issue: I want the scheduled task to launch the batch independent of
any user being logged on. Is there a "master user" on wts?

Not to my knowledge but I don't know much about the internals of
servers and TS. Just how to get Access going on them efficiently.
Even if there was I'd get IT to setup a special account just for this
purpose with a password which never expires and just enough
permissions to do what is required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/