VBA to open back-end network location with user/password

[rvsebi]

Hi,
I work with split database and i keep back-end on a NAS server. When i copy first time the front-end to user i need to use credentials(user/password) to open NAS share.
How can i use vba with this credentials on open of front-end and on close to delete them?
Something like map network drive and delete mapped drive on close but without mapping because i dont want user to see the path to back-end and access it.
Thank you in advance!

 

[The_Doc_Man]

Look up the URS mapping scheme (if it can work in your case) for which your links are not drive-letter mapped in the first place.

URS is where you have the back end linked with \\server\share\folder\folder\...\x.mdb (or of course .accdb)

 

[sneuberg]

This thread says something about Cmdkey.exe being the command line way of getting to the credentials manager. Maybe you could do this via the Shell function.

 

[rvsebi]

This thread says something about Cmdkey.exe being the command line way of getting to the credentials manager. Maybe you could do this via the Shell function.

Thank you sneuberg.
I tried cmdkey and is good to delete credentials for specific connection but if i dont close the user session (log off/log on) user still can access the path to back-end.
Shell supose to have other batch file to be executed and i dont want that.

 

[rvsebi]

Look up the URS mapping scheme (if it can work in your case) for which your links are not drive-letter mapped in the first place.

URS is where you have the back end linked with \\server\share\folder\folder\...\x.mdb (or of course .accdb)

Thank you The_Doc_Man.
Can you be more specific with this URS please.