File Sharing Problems

Fix Access 2016 Insert OLE Object Not Working Over RDP

John WilsonJohn Wilson Nov 2, 2026 868 views

Question details

Users are unable to open the Insert Object dialog for OLE Object fields when running Microsoft Access through a Remote Desktop connection.

How to Fix Access 2016 Insert OLE Object Failing Over RDP
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Remote Desktop Connection

Launch the Remote Desktop Connection app on your local computer.

2
Access Local Resources

Click 'Show Options' at the bottom left, then navigate to the 'Local Resources' tab.

3
Configure Devices and Resources

Under the 'Local devices and resources' section, click the 'More...' button.

4
Enable Drive Sharing

Check the box next to 'Drives' to share your local hard drives with the remote session, then click 'OK'.

5
Connect and Test

Connect to your remote session, open Access, and try the Insert Object command again.

Enable Local Drive Redirection in RDP Settings
Drive Redirection: Your local drives will now appear in the remote computer's file explorer under 'Devices and drives', allowing Access to attach them.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight architecture that runs fast without the need for complex remote setupsFamiliar user interface makes transitioning completely seamlessFree to use with built-in PDF editing tools
microsoft office alternative - wps office

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.