Save to Local Desktop from a Virtual Machine

[Richard Horne]

Hey guys.

Our Access DB has a button that allows users to save a PDF of the report they're working on, to their desktop.

We are moving our Access Database online to be run from an Azure Virtual Machine, but this button now saves the report to the VM's desktop instead of the local desktop.

'Get the desktop location
strPath = CreateObject("WScript.Shell").SpecialFolders("Desktop")

Is there a special folders equivalent for the local desktop? This needs to be dynamic because the VM could be accessed from any number of computers.

 

[Minty]

I'm not sure that a VM would be aware of the current users "local desktop", I don't know how it could know.
What if you were using a tablet or phone or a Mac to access the VM - there is no local "Documents" folder?

 

[Richard Horne]

I'm working on the assumption this will only ever be accessed by a Windows device with a desktop.

 

[theDBguy]

I'm working on the assumption this will only ever be accessed by a Windows device with a desktop.

Hi. Do you know how the users would be accessing the VM? Would they be using a bridged network or RDP?

 

[Richard Horne]

There will be 10-15 users tops and they're using RDP through Microsoft's own Remote Desktop App.

 

[theDBguy]

There will be 10-15 users tops and they're using RDP through Microsoft's own Remote Desktop App.

In that case, you might look into RDP Virtual Channels.

Using Remote Desktop Services virtual channels - Win32 apps

To implement a virtual channel, you provide the server and client modules of a virtual channel's application.

docs.microsoft.com

Dynamic Virtual Channels | Microsoft Community Hub

First published on CloudBlogs on Sep, 20 2007 An important goal of the Terminal Services (TS) team is to provide a product that can easily be extended...

techcommunity.microsoft.com