Import objects in Access
To use the Forms, Tables, Queries and Modules between two Access applications, use ‘Import objects’. This import option is most commonly used when changing the version of Access. If we have a form in version 2000 and we need to create the same form in version 2016 then we can import the form from 2000 to 2016 using this process.
The following steps are used to import any object from one version to another. Here, a form is imported.
Consider the form “frmGreetingCard” in an application that is imported to the new version.
Open an Access Application and click Access from the Import & Link group of External Data Tab in the Microsoft Access Ribbon.
A ‘Get External Data – Access Database’ dialog box will pop up. Click Browse to select the file name.
Select the file in the dialog box and click Open.
In ‘Import Objects,’ all the table, queries, forms, reports, etc. of an imported application will be displayed.
Select “frmGreetingCard” from the Forms tab and click OK.
Select Close in ‘Get External Data – Access Database.’
Now the form is imported successfully to the other version.
You can also use this function to import Queries, Tables, Reports and Modules.
By Admin at 26 Jul 2016, 12:07 PM