It's very convenient to run another PC from your current PC. Whether it's another machine in your office, network, or physical location, Windows offers a Remote Desktop Connection feature to do so.
This is particularly valuable to:
Our consulting team can help you evaluate the options and tradeoffs, and implement a migration path to ensure a smooth transition to a remote hosted platform. For more information visit our page, Running Microsoft Access via Remote Desktop and Remote App including Hosting on the Microsoft Azure Cloud.
To enable this feature, the PC needs to allow remote desktop and specify who can connect. You can press the Windows Key and R to open the Run Window and enter sysdm.cpl [Enter].
Or from the Control Panel choose System Settings (or from Windows Explorer, choose Computer, right click Properties). From there, click on the Advanced System Settings option:
On the first tab, note the computer name which is its unique name on your network. You'll need to know that when you remote to it from another PC. It can be a name or IP address:
Click on the Remote tab, and allow connections to the PC:
Click on the [Select Users] button to specify who can connect to the PC. Be sure to include the login you use if it's different from the administrator on that machine:
The machine is now set to allow another PC to log into it and run it.
From the Windows menu, choose "Remote Desktop Connection". This screen appears:
Enter the name of the Computer we saved earlier and press [Connect].
You'll need to enter your login credentials the first time.
Check the "Remember my credentials" box so you won't need to enter it every time you connect.
There may be some problems when you try to connect.
You may encounter this error when you try to connect:
If so, it means your network isn't setup for Transport Level Security (TLS). You can get around this by updating the remote PC and setting its Remote Desktop option to less secure:
If you encounter this error, it usually means the remote PC was setup on the network before the current domain trust system was updated. To fix this by updating the remote PC's network connection. Go back to the Computer Name tab and press the [Network ID] button. Just step through the Wizard to refresh it.
When you connect for the first time, a prompt asks you to validate the certificate of the remote computer:
Avoid seeing this again by checking the box "Don't ask me again for connections to this computer"
Once connected, your remote PC appears in a Window:
You can maximize it to full screen and it'll feel like you're on that computer. The only difference is a connection bar (moveable) that appears at the top to identify the remote PC.
Note that unless the PC is a server O/S, only one user can remote to it at a time. If another remote session is running, that user is kicked out when you connect. To support multiple simultaneous users, setup Terminal Services with RemoteApp.
Having multiple monitors on a PC is a huge productivity booster; people usually connect remotely in just one monitor.
Fortunately, there's a feature to let you also use multiple monitors remotely. If you have two monitors and the PC you're connecting to has two, you can run both monitors remotely as well. Click on Options, go to the Display tab and check "Use all my monitors for the remote session".
Note that the Display tab also lets you set the screen resolution if the remote PC is using a different resolution or screen size than your local monitor.
Have any suggestions or comments? Head to our blog post Tips and Techniques for Setting up Remote Desktop Connections and Using Multiple Displays and leave us your feedback!
Microsoft Access within an Organization's Database Strategy
How many simultaneous Microsoft Access users?
Blaming Microsoft Access instead of the Developer
Microsoft Access Version Feature Differences
Microsoft Access Versions, Service Packs and Updates
Microsoft Office 365 Access Update Version Releases
Top 14 Features Added with MS Access 2007
Taking Over Legacy MS Access Databases
Winner of Every Best Access Add-in Award
Split Database Architecture for Multiuser
Set AutoNumber Starting Number Other than 1
Avoid Unnecessary or Duplicate Indexes
Replace Attachment Field Paperclip Icon
Copy Command Button and Keep Picture
Module VBA to Forms and Controls
Subform Reference to Control Rather than Field
Suppress Page Headers and Footers on the First Page of Your Report
Annual Monthly Crosstab Columns
Add Buttons to the Quick Access Toolbar
Collapse the Office Ribbon for more space
Avoid Exits in the Body of a Procedure
Send Emails with DoCmd.SendObject
Error Handling and Debugging Techniques
Error Number and Description Reference
Remote Desktop Connection Setup
Terminal Services and RemoteApp Deployment
Missing Package & Deployment Wizard
Remove 'Save to SharePoint Site' Prompt from an Access Database
Class Not Registered Run-time Error -2147221164
Microsoft Access to SQL Server Upsizing Center
When and How to Upsize Access to SQL Server
SQL Server Express Versions and Downloads
Deploying MS Access Linked to SQL Azure
SQL Server Azure Usage and DTU Limits