-
Notifications
You must be signed in to change notification settings - Fork 53
Supported Objects
This page outlines the types of objects and information that can be exported from a Microsoft Access Database and which items are supported when building a database from source files. If you find that you are missing something in the export or import, please open an issue and link it to the appropriate row in the table.
Legend: ✔️ Fully supported
Most types of objects can be exported and imported using this tool.
| Type | Export | Import |
|---|---|---|
| Tables | ✔️ | ✔️ |
| Queries | ✔️ | ✔️ |
| Forms | ✔️ | ✔️ |
| Reports | ✔️ | ✔️ |
| Macros | ✔️ | ✔️ |
| Modules | ✔️ | ✔️ |
| Database Settings | ✔️ | ✔️ |
If you are looking for a specific type of object or property that you want to export or import, you can refer to the following more comprehensive list. (Updates and additions welcome.)
The Testing column indicates whether a test item and testing code has been created in the Testing.accdb database to verify that particular item after import from source code. Test location indicates where to find the object in the database.
| Type | Export | Import | VBA Class | Testing | Test Location |
|---|---|---|---|---|---|
| 💼 TABLES | |||||
| Access Table | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblInternal |
| Extended Properties | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblInternal |
| Table SQL | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblInternal |
| Linked Table | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblLinkedAccess |
| Linked PrimaryKey | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblLinkedAccess |
| ODBC Table | ✔️ | ✔️ | clsDbTableDef | ||
| Linked Structure | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblLinkedAccess |
| Table Data (TDF) | ✔️ | ✔️ | clsDbTableData | ✔️ | tblInternal.txt |
| Table Data (XML) | ✔️ | ✔️ | clsDbTableData | ✔️ | tblSaveXML.xml |
| Table Data Macros | ✔️ | ✔️ | clsDbTableDataMacro | ✔️ | tblSaveXML |
| 💼 QUERIES | |||||
| Designer Layout | ✔️ | ✔️ | clsDbQuery | ||
| SQL Output | ✔️ | ✔️ | clsDbQuery | ||
| Pass Through Queries | ✔️ | ✔️ | clsDbQuery | ||
| 💼 FORMS | |||||
| Form objects | ✔️ | ✔️ | clsDbForm | ||
| Saved print settings | ✔️ | ✔️ | clsDbReport | Optional | |
| 💼 REPORTS | |||||
| Report objects | ✔️ | ✔️ | clsDbReport | ||
| Saved print settings | ✔️ | ✔️ | clsDbReport | Optional | |
| 💼 MACROS | |||||
| Macro objects | ✔️ | ✔️ | clsDbMacro | ||
| 💼 MODULES | |||||
| Standard Modules | ✔️ | ✔️ | clsDbModule | ||
| Class Modules | ✔️ | ✔️ | clsDbModule | ||
| Object Modules | ✔️ | ✔️ | clsDbModule | ||
| Hidden VBE Attributes | ✔️ | ✔️ | clsDbModule | ||
| 💼 DATABASE | |||||
| DAO Properties | ✔️ | ✔️ | clsDbProperty | ||
| Project Properties | ✔️ | ✔️ | clsDbProjProperty | ||
| Object Descriptions | ✔️ | ✔️ | clsDbDocument | ||
| Hidden Attribute | ✔️ | ✔️ | clsDbHiddenAttribute | ||
| Remove Personal Info | ✔️ | ✔️ | clsDbProject | ||
| Application Icon | ✔️ | ✔️ | clsDbProperty | ||
| Embedded Images | ✔️ | ✔️ | clsDbSharedImage | ||
| Saved Imp/Exp Specs | ✔️ | ✔️ | clsDbSavedSpec | ||
| System Imp/Exp Specs | ✔️ | ✔️ | clsDbImexSpec | ||
| Summary Properties | ✔️ | ✔️ | clsDbDocument | ||
| Relationships | ✔️ | ✔️ | clsDbRelation | ||
| Nav. Pane Groups | ✔️ | ✔️ | clsDbNavPaneGroup | ||
| Embedded Office Theme(s) | ✔️ | ✔️ | clsDbTheme | ||
| CommandBars (Menus and Toolbars) | ✔️ | ◒ | clsDbCommandBars | ||
| 💼 VBE PROJECT | |||||
| Project Properties | ✔️ | ✔️ | clsDbVbeProject | ||
| Compilation Arguments | ✔️ | ✔️ | clsDbVbeProject | ||
| GUID References | ✔️ | ✔️ | clsDbVbeReference | ||
| File/Lib References | ✔️ | ✔️ | clsDbVbeReference | ||
| Forms 2.0 documents | ✔️ | ✔️ | clsDbVbeForm | ||
| 💼 ADP PROJECTS | |||||
| Connection Settings | clsDbProjProperty | ||||
| SQL Functions | ✔️ | n/a | clsAdpFunction | ||
| SQL Views | ✔️ | n/a | clsAdpServerView | ||
| SQL Stored Procedures | ✔️ | n/a | clsAdpProcedure | ||
| SQL Tables | ✔️ | n/a | clsAdpTable | ||
| SQL Triggers | ✔️ | n/a | clsAdpTrigger | ||
| 💼 EXTERNAL DATABASE | |||||
| Microsoft SQL | ✔️ | n/a | clsSchemaMsSql | ||
| MySQL/MariaDB | ✔️ | n/a | clsSchemaMySql | ||
| 💼 OTHER | |||||
| Saved VCS Options | ✔️ | ✔️ | clsOptions |
Working with *.adp files is very similar to working with regular (MDB) Microsoft Access databases. All of the main database objects can be exported and imported just like MDB files. When it comes to SQL server objects, the object definitions are exported for tracking in source control, but this system does not attempt to modify any SQL server objects. (Hence the n/a note on importing SQL objects.)
All commandbars can be exported. However, there are known instances of legacy commandbars that may fail to import. In those cases, those commandbars are "built-in" but are in fact customized version. If the commandbar's Id no longer exists in the Access, the build will fail. We do handle a subset of the custom built-in Access commandbars, particularly those designed to open a specific Access object. Here's a table of supported custom built-in commandbars:
| Id | Command |
|---|---|
| 1835 | Open Table |
| 1836 | Open Query |
| 1837 | Open Form |
| 1838 | Open Report |
| 1839 | Run Marco |
| 3885 | Open Access Data Page |
| 3886 | Open Server View (ADP) |
| 3888 | Open Stored Procedure (ADP) |
NOTE: The database diagram command is not included because we were unable to create a custom commandbar with this Id. If anyone has this and wish to support this, submit a PR including the commandbar.
If your application project contains legacy ocmmandbars that cannot be built becuase they are custom and are not in the list, and you do not wish to lose the functionality, you can make use of the After Build procedure and perform the import. You can call ImportCommandBars routine to perform the import from a template file. For an example of this, refer to the code here and here.
This add-in is designed to work in Microsoft Access 2010 and newer. Access 2007 users, please see this issue.
Missing something? Create an issue or a pull request.