Fix Access 2016 Insert OLE Object Not Working Over RDP
Question details
Users are unable to open the Insert Object dialog for OLE Object fields when running Microsoft Access through a Remote Desktop connection.

- Product
- Microsoft Access 2016
- Device & OS
- Windows
- Scenario
- Inserting OLE object attachments into an Access database over a Remote Desktop connection.
- Observed behavior
- Copying and pasting images works, but the 'Insert Object' dialog cannot be opened for OLE Object fields over RDP, even though the feature works perfectly when Access is run locally.
Ensure you have access to modify the Remote Desktop Connection client settings on your local machine and permission to change database options within Microsoft Access.
Enable Local Drive Redirection in RDP Settings
Share your local drives with the remote session so Access can locate and insert local files as OLE objects.
When running an application on a remote computer, it cannot see the files stored on your physical local machine by default. Redirecting your local drives allows the remote Access session to browse and insert your local files.
Launch the Remote Desktop Connection app on your local computer.
Click 'Show Options' at the bottom left, then navigate to the 'Local Resources' tab.
Under the 'Local devices and resources' section, click the 'More...' button.
Check the box next to 'Drives' to share your local hard drives with the remote session, then click 'OK'.
Connect to your remote session, open Access, and try the Insert Object command again.

Enable Default Shortcut Menus in Access
Ensure the right-click context menu is enabled in your database, as it is required to access the Insert Object command.
Looking for a Seamless, Free Office Suite?
While Microsoft Access provides powerful database management, handling complex remote setups and OLE objects can be tedious. If your daily workflow mainly involves documents, spreadsheets, and presentations, WPS Office is an excellent, lightweight alternative. It operates efficiently on local machines without heavy configuration, eliminating many remote desktop compatibility headaches.

Frequently Asked Questions
Why can I copy and paste images but not use the Insert Object dialog over RDP?
Copying and pasting utilizes the shared system clipboard, which Remote Desktop handles by default. The 'Insert Object' dialog, however, needs to access the file system to locate the specific document or image. If your local drives aren't shared via RDP settings, Access cannot find the file to create an OLE link.
Can I insert an OLE object without using the right-click menu?
While the right-click context menu is the standard method for OLE fields, you can sometimes use keyboard shortcuts (like Shift+F10 to simulate a right-click) or access object insertion tools via the Access Ribbon if a specific control has focus, provided shortcut menus are enabled in the database options.
Does drive redirection in RDP pose any security risks?
Redirecting local drives exposes your local file system to the remote computer. If the remote machine is compromised or untrusted, there is a risk of unauthorized file access or malware transfer. Only enable drive redirection when connecting to trusted servers.




