Access a secure folder on a server

[Pastor Del]

My Access 2000 application needs to be the only way to access a secure folder
on a server. It needs to do this while being run from a server by multiple
computers. I've tried programmatically logging on the netword as the only
user allowed access to the folder but the user using the application is
already logged on and each computer is only allowed one log on at a time.

Can anyone offer a suggestion & maybe some code examples. I'm getting
outside my experience with this.

 

[Adam Simpson]

I have done this using the RunAs command, but the commands can become quite
tricky (see example below). If you could save the file items as blobs in a
database it would be easier.
If you do use runas the first time you run the command in a profile you have
to supply the user password manually as you can not pipe the passwords in.

Shell("runas /savecred /user:" & DocU & " " & """cmd.exe /C " & IIf(MC = 1,
"move", "Copy") & " \""" & ffn & "\"" \""" & rf & "\""
Adam