> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Hidden Feature: Drag and Drop Access Objects Between Files
- URL: https://nolongerset.com/drag-and-drop-access-objects/
- Published: 2021-12-03T03:09:46.000Z
- Updated: 2026-05-08T13:01:02.000Z
- Description: Skip the "Import Access Objects" dialog screens and use your mouse to move Tables, Queries, Forms, Reports, and code modules between Access files.
- Author: Mike Wolfe
- Tags: Hidden Features, #Import 2026-05-20 02:59

## Did You Know...

...that you can copy Access objects between .accdb/.mdb files by simply dragging and dropping them between their navigation panes? 

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/0D4C4586-6C10-49C3-A637-64D1019076B6.GIF)

This is much more convenient than performing a typical Access object import via the ribbon interface (External Data > New Data Source > From Database > Access...), especially if both Access applications are already open.

### Items of Note

Be aware that you can only drop the object inside the target file's **Navigation Pane** (not the main Access canvas area).

You can copy multiple objects at a time from the source file. Perform a \[Ctrl\] click to add objects to your selection one at a time or a \[Shift\] click to select a consecutive group of objects.

If one (or more) of the objects you are copying has the same name as an object in the destination file, Access will give you a chance to rename the object. If you keep the original name, you will get one more chance to confirm that you really want to overwrite the object in the destination file.

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/image-1.png)

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/image.png)

### Old Dogs *Can* Learn New Tricks

Maybe this isn't a hidden feature. Maybe I'm just late to the party. 

Whatever the case may be, I think it's great that after nearly a decade and a half of developing applications in Access, I still have more to learn.

### Acknowledgements

Shout-out to Colin Riddington of [Mendip Data Systems](http://www.mendipdatasystems.co.uk/) for introducing me to this feature. Thanks, Colin!

*Image by [Anna Powałowska](https://pixabay.com/users/annapowa-17446403/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=6724085) from [Pixabay](https://pixabay.com/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=6724085)*