473,695 Members | 2,054 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

TIP: Drag & Drop with Database Objects

isladogs
460 Recognized Expert Moderator Contributor
I first wrote about this back in Jan 2018 at another forum.

It appears that the following info is not widely known, even amongst experienced developers, so I'm mentioning it again in other places.
In fact, after hearing about it from me, Mike Wolfe has just written an article on the subject Hidden Feature: Drag and Drop Access Objects Between Files (nolongerset.co m).

After almost 20 years using Access, it amazes me that I still find out new things all the time...

1. Transfer objects between databases using drag & drop
In the past, whenever I wanted to copy objects to a new database, I always did so by importing or exporting using the usual methods
By chance, a few years ago I discovered you can drag & drop as well! MUCH easier...!
Holding down Shift & Control allows multi-select in the usual way.

This method allows you to drag and drop any object from the navigation pane of one database into another.

The only drawback I can see is that linked tables in the source database become local tables in the destination database....whi ch may not be what you want.
Holding down Ctrl or Alt or Shift etc has no effect on this behaviour. A work-round to this is available but it is far from intuitive....
Drag the linked table(s) across to the other database a second time. This time Access will ask you what to do with the table(s) ...select linked table and the local table will be replaced by a linked table.

If this is also a "well I never knew that" moment for you, do have a look at the two linked videos which show this in use - not quite Oscar winning standard on this occasion
DragDropDBObjec ts
DragDrop2

And if the rest of you already knew you could do this ... perhaps it just proves how little I really know.

2. Access object shortcuts
On a similar theme, if you drag any Access object such as a table onto the desktop, a shortcut is created in the desktop. The table shortcut will have a suffix of .MAT.
When the shortcut is double-clicked, the database opens directly to the table.
Or you can right click to open in design view etc.

This feature works for any Access object e.g. Form shortcut .MAF; Query .MAQ; Report .MAR; Module .MAD etc. In fact there are 10 different shortcut types as shown below (plus a rather strange file type .MAU)



I've no idea what the diagram object is that would give a .MAG shortcut ...nor do I know what a .MAU file is.
Personally, the only time I’ve ever found this shortcut feature useful is for quick access to items in a DEMO session.

UPDATE:
I've just uploaded a video on this topic to my Isladogs on Access You Tube channel
Dec 4 '21 #1
1 18284
isladogs
460 Recognized Expert Moderator Contributor
For info, a member of the Access team informed me that both .MAG shortcuts and .MAU files refer to a long deprecated Access feature: Data Access Pages. That was a very early attempt to put Access on the web back in Access 2000.
Dec 12 '21 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
4165
by: srikanth | last post by:
Hi all, I have an requirement in one of my projects. We have one aspx page, in that we have two frames, in each frame having a tree structure control(dynamic data). In the left Frame we are displaying all the documentcollections(dynamic) in the Treestructure, In the Right side we are displaying all the HolderGroups (dynamic).We have to assing Any one of the Documentcollections to HolderGroups, through Drag and Drop
1
7637
by: Karsten Schramm | last post by:
Hi, if I drag an Outlook.MailItem to a Windows-Explorer window a <subject>.msg file will be created. Now I try to drag & drop a mail item to my own WinForm app. Unfortunately it doesn't work. In the "drop event" are eight DataFormats (e.Data.GetFormats()) but the important one (imho) "FileContents" is "Nothing"/"null".
0
1483
by: David Winter | last post by:
I have a particular application that requires reordering objects by drag and drop, and I would like to do this with a web frontend. To be more precise: There are headlines and paragraphs stored in a database, but forcing the editors to put them into a certain sequence by entering a sequence number for every item (or clicking on an "up" button fifty times) would be much too cumbersome. So I want to give them an outline view of the text...
2
9198
by: Grey | last post by:
I need to design a workflow application with C#. I want to design an UI with some workflow components which they can be drag & drop anywhere in order to design the workflow for the application users. Moreover, when the user double click on the component, they can define some routing rules for the process. Is it possible to have such fancy UI in C#?? Any reference sites or tutorial?? Million Thanks.
2
4495
by: Barry Moon | last post by:
Hi Can anyone give me any help with passing an object across processes, via drag and drop? I've written a custom ListView control, which supports dragging and dropping of its items. The drag and drop works fine within the same application, but fails
2
2798
by: Ivo Tcholakov | last post by:
Is it possible to drag and drop controls in an aspx page at runtime ? Meaning i have developed a ASP.NET web form, the web form is now downloaded in IE - now can i have this form to detect mouse events, and provide drag and drop functionality of the controls ? Thank You Ivo Tcholakov
3
3879
by: Goldwind | last post by:
Hi, I"m trying to use drag & drop of text from one text box to another but without suceess. Microsoft presented an example in "101 code samples" BUT in this example the code select and drag all the text in the TextBox, wether the user wants or not. I need to drag only the selected text (changing the example causes it not to work).
3
10592
by: VB Programmer | last post by:
In VB.NET 2005 (winform) any sample code to drag & drop items between 2 listboxes? Thanks!
5
13780
by: Romulo NF | last post by:
Greetings, I´m back here to show the new version of the drag & drop table columns (original script ). I´ve found some issues with the old script, specially when trying to use 2 tables with drag&drop on the same page (which was not possible). Now i´ve a new concept of the script, more object oriented. I´ve also commented the whole code so you guys can easier understand it engine. What exactly we need when trying to make a column drag &...
1
3828
by: patrickq | last post by:
What am trying to achieve is dragging an element from one IFRAME/FRAME into another IFRAME/FRAME. But upon dropping the element, I do not want the target IFRAME/FRAME to open/load it. I want to set the data type to "text" at the source, so that the drop operation simply drops a set text string onto a target text entry field. Under IE, when dragging an object, it is possible to catch the “dataTransfer.setData” event to set up the data to be...
0
8650
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9004
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7685
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6510
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5843
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4597
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3025
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2290
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1987
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.