<div>
A reliable method is to copy the Access file from the remote machine to a local folder or a shared folder on your local network, then let Excel import from the copy.<br />
<br />
/gustav
</div>


A reliable method is to copy the Access file from the remote machine to a local folder or a shared folder on your local network, then let Excel import from the copy.

/gustav

<div>
We're unable to do that because the Excel workbook is used by various people to import data - and the Access db is updated daily at various times. &nbsp;Also, not everyone has access to the VM.
</div>


We're unable to do that because the Excel workbook is used by various people to import data - and the Access db is updated daily at various times.  Also, not everyone has access to the VM.

<div>
Your going to need a share on the Azure VM for the Access DB to be accessible. &nbsp;This will be a separate logon from your RDP credentials most likely.<br />
<br />
<a href="https://blogs.technet.microsoft.com/canitpro/2015/11/30/step-by-step-setting-up-azure-smb-file-share/" rel="ugc">https://blogs.technet.microsoft.com/canitpro/2015/11/30/step-by-step-setting-up-azure-smb-file-share/</a><br />
<br />
Jim.
</div>


Your going to need a share on the Azure VM for the Access DB to be accessible.  This will be a separate logon from your RDP credentials most likely.

https://blogs.technet.microsoft.com/canitpro/2015/11/30/step-by-step-setting-up-azure-smb-file-share/ [https://blogs.technet.microsoft.com/canitpro/2015/11/30/step-by-step-setting-up-azure-smb-file-share/]

Jim.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I currently have Excel importing data from an Access db, however, the database is moving to a Virtual Machine that we have with MS Azure.<br />
I am unsure what I need to do to connect to the db once it's moved. &nbsp;The Excel will still be on my local machine.<br />
We currently login to the VM via Remote Desktop Connection. &nbsp;Within the VBA, what do I need? &nbsp;Do I need to enter the password (as I do when I connect via RDC)?<br />
<br />
thanks in advance<br />
Kerry
</div>
</div>


Hi,
I currently have Excel importing data from an Access db, however, the database is moving to a Virtual Machine that we have with MS Azure.
I am unsure what I need to do to connect to the db once it's moved.  The Excel will still be on my local machine.
We currently login to the VM via Remote Desktop Connection.  Within the VBA, what do I need?  Do I need to enter the password (as I do when I connect via RDC)?

thanks in advance
Kerry

VBA to Access db on Virtual Machine

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Virtual Server was a virtualization solution that facilitated the creation of virtual machines on the Windows XP, Windows Vista and Windows Server 2003 operating systems. Virtual machines are created and managed through a web-based interface that relies on Internet Information Services (IIS) or through a Windows client application tool called VMRCplus. Features included Linux guest operating system support, Virtual Disk Precompactor, symmetric multiprocessing (SMP), x64 host operating system support, the ability to mount virtual hard drives on the host machine and additional operating systems support, including Windows Vista, and a volume shadow copy writer.

Microsoft Virtual Server

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.