-
Notifications
You must be signed in to change notification settings - Fork 59
Supported Objects
joyfullservice edited this page Apr 22, 2020
·
18 revisions
Note: This page is a work in progress...
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.
Most types of objects can be exported and imported using this tool.
| Type | Export | Import | Notes |
|---|---|---|---|
| Tables | ✔️ | ||
| Queries | ✔️ | ||
| Forms | ✔️ | ||
| Reports | ✔️ | ||
| Macros | ✔️ | ||
| Modules | ✔️ | ||
| Database Properties | ✔️ | ❌ | See below for additional notes |
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 list. (Updates and additions welcome.)
| Type | Export | Import | Notes |
|---|---|---|---|
| 💼 TABLES | |||
| Access Table | ✔️ | ||
| Table SQL | ✔️ | ||
| Linked Table | ✔️ | ||
| ODBC Table | ✔️ | ||
| Linked Structure | ✔️ | See options | |
| Relationships | ✔️ | ||
| Table Data | ✔️ | Select tables in options | |
| Data Macros | |||
| 💼 QUERIES | |||
| Designer Layout | ✔️ | ||
| SQL Output | ✔️ | ||
| Formatted SQL | ✔️ | ||
| Pass Through Queries | ✔️ | ||
| 💼 FORMS | |||
| 💼 REPORTS | |||
| 💼 MACROS | |||
| 💼 MODULES | |||
| 💼 DATABASE | |||
| Database Properties | See options | ||
| Custom Properties | |||
| Application Icon | |||
| Embedded Images |
Missing something? Create an issue or a pull request.