Impersonate User Account

[Khalid_Afridi]

Hi,
I want to allow domain users to access a shared folder on a windows server 2003 using its local users as Impersonate User Account to access accdb database containing linked tables from that shared folder.

the server 2003 is not a member of our domain. so i have created a local user which has access to the sahred folder.

so any idea how to do it. is there any way to execute vba code before establishing the link with the tables.

thanks!

 

[Banana]

I think the best way to do this is to use a RunAs utility and a script to open Access database with RunAs (you could use a shortcut to do that, IINM). When the Access is opened via RunAs with a different credentials they'll be now able to link to tables in the secured folder.

Be aware that there is a security hole in RunAs utility where if you choose to save credentials it will enable any savvy user to just use RunAs in a command prompt to do anything else. Therefore the impersonated user should have no other permissions other than opening Access & that particular folder and user's own folder.

I briefly toyed with the idea of using RunAs & Windows permisssions but I've never actually implemented this. Felt more trouble than helpful.

HTH.

 

[Khalid_Afridi]

I think the best way to do this is to use a RunAs utility and a script to open Access database with RunAs (you could use a shortcut to do that, IINM). When the Access is opened via RunAs with a different credentials they'll be now able to link to tables in the secured folder.

Be aware that there is a security hole in RunAs utility where if you choose to save credentials it will enable any savvy user to just use RunAs in a command prompt to do anything else. HTH.

The user has given only the read write access to that share folder. he can not access other folders on the server.

can you show me how to use RunAs utilty and script, any example/link etc please.

How can we use RunAs utilty to access the share folder for that specific user: (the server is not a domain member)

many thanks!