-
Notifications
You must be signed in to change notification settings - Fork 59
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 | Notes |
|---|---|---|---|---|---|---|
| 💼 TABLES | ||||||
| Access Table | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblInternal | |
| Table SQL | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblInternal | |
| Linked Table | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblLinkedCSV | |
| Linked PrimaryKey | ✔️ | ✔️ | clsDbTableDef | |||
| ODBC Table | ✔️ | ✔️ | clsDbTableDef | |||
| Linked Structure | ✔️ | ✔️ | clsDbTableDef | ✔️ | tblLinkedCSV | |
| Table Data (TDF) | ✔️ | ✔️ | clsDbTableData | ✔️ | tblInternal | |
| Table Data (XML) | ✔️ | ✔️ | clsDbTableData | ✔️ | tblSaveXML | |
| Relationships | ✔️ | ✔️ | clsDbRelation | ✔️ | Relationships | tblInternal-tblSaveXML |
| Table Data Macros | ✔️ | ✔️ | clsDbTableDataMacro | ✔️ | tblSaveXML | Sets UpdateDate after edit |
| 💼 QUERIES | ||||||
| Designer Layout | ✔️ | ✔️ | clsDbQuery | |||
| SQL Output | ✔️ | ✔️ | clsDbQuery | |||
| Formatted SQL | ❌ | Planned but not finished | ||||
| Pass Through Queries | ✔️ | ✔️ | clsDbQuery | |||
| 💼 FORMS | ||||||
| Form objects | ✔️ | ✔️ | clsDbForm | |||
| 💼 REPORTS | ||||||
| Report objects | ✔️ | ✔️ | clsDbReport | |||
| Saved print settings | ✔️ | ✔️ | clsDbReport | Optional | ||
| 💼 MACROS | ||||||
| Macro objects | ✔️ | ✔️ | clsDbMacro | |||
| 💼 MODULES | ||||||
| Standard Modules | ✔️ | ✔️ | clsDbModule | |||
| Class Modules | ✔️ | ✔️ | clsDbModule | |||
| Object Modules | ✔️ | ✔️ | clsDbModule | |||
| 💼 DATABASE | ||||||
| DAO Properties | ✔️ | ✔️ | clsDbProperty | |||
| Project Properties | ✔️ | ✔️ | clsDbProjProperty | |||
| Object Descriptions | ||||||
| Application Icon | ✔️ | ✔️ | clsDbProperty* | clsDbProjProperty for ADP | ||
| Embedded Images | ||||||
| Saved Imp/Exp Specs | ✔️ | ✔️ | clsDbSavedSpec | |||
| System Imp/Exp Specs | ✔️ | ✔️ | clsDbImexSpec | |||
| File Properties | ||||||
| Nav. Pane Groups | ||||||
| 💼 VBE PROJECT | ||||||
| Project Properties | ✔️ | ✔️ | clsDbVbeProject | |||
| GUID References | ✔️ | ✔️ | clsDbVbeReference | |||
| File/Lib References | ✔️ | ✔️ | clsDbVbeReference | |||
| Forms 2.0 documents | ||||||
| 💼 ADP PROJECTS | ||||||
| Access Components | ✔️ | ✔️ | (Multiple) | Forms, Reports, Code, etc.. | ||
| Connection Settings | clsDbProjProperty | |||||
| SQL Functions | ✔️ | ❌ | clsAdpFunction | |||
| SQL Views | ✔️ | ❌ | clsAdpServerView | |||
| SQL Stored Procedures | ✔️ | ❌ | clsAdpProcedure | |||
| SQL Tables | ✔️ | ❌ | clsAdpTable | |||
| SQL Triggers | ✔️ | ❌ | clsAdpTrigger | |||
| 💼 OTHER | ||||||
| Saved VCS Options | ✔️ | ✔️ | clsOptions |
Missing something? Create an issue or a pull request.