How to connect to network drive as another user?

[Andrey]

Hi,

Does it possible to connect to files located on the network drive with login
and password differ from current user?
I use MS Access 97 & 2000 under Windows 2000 and XP.
If MS Access can not do it, does it possible via Windows API?


Thank you in advance.
Andrey

 

[Alex White MCDBA MCSE]

No, because windows is always going to try your current credentials first,
but saying that look into 'Net Use' command and API equivalent, I know that
if you are already connected to a specific resource it is going to complain
like mad.

What are you trying to achieve as there maybe another way round the problem?

 

[Andrey]

Alex,
thank you for the answer!

I'm trying to open files from a set of folders, i.e.:
In one folder, say, T:\Public\Users\, there are a set of subfolders:
T:\Public\Users\User001\
T:\Public\Users\User002\
....
T:\Public\Users\User200\

Folders may contain different files, which must be protected from changes by
all users except owner of the folder (i.e. with login "Use001" can modify
all files inside folder "T:\Public\Users\User001\", but can not modify files
in other folders).

First idea was to ask IT department to make security settings using file
server, but I think this will take a lot of their time.

Best regards
Andrey