isladogs
MVP / VIP
- Local time
- Today, 20:11
- Joined
- Jan 14, 2017
- Messages
- 18,827
After almost 20 years using Access, it amazes me that I still find out new things all the time...
When I want to copy objects to a new database, I have always done so by importing or exporting by the usual methods
By chance I just discovered you can drag & drop as well! MUCH easier...!
Holding down shift & control allow multi-select in the usual way
The only drawback I can see is that linked tables in the source database become local tables in the destination database
If this is also a "well I never knew that " moment for you, do have a look at the attached video which shows this in use - not quite Oscar winning standard on this occasion
And if the rest of you already knew you could do this ... perhaps it just proves how little I really know
When I want to copy objects to a new database, I have always done so by importing or exporting by the usual methods
By chance I just discovered you can drag & drop as well! MUCH easier...!
Holding down shift & control allow multi-select in the usual way
The only drawback I can see is that linked tables in the source database become local tables in the destination database
If this is also a "well I never knew that " moment for you, do have a look at the attached video which shows this in use - not quite Oscar winning standard on this occasion
And if the rest of you already knew you could do this ... perhaps it just proves how little I really know
Attachments
Last edited: