How to convert an Access model to an MDB file that can be opened in Access? (4222080)

How to convert an Access model to an MDB file that can be opened in Access?

1. While Access module is opened select Model | Generate DDL Script menu option. This will save the file to a SQL file.
2. Open SQL file with Notepad or any text editor
3. File will contain a comment section in its header section on how to create a Module in Access and copy/paste and run the SQL script. Running the script in SQL Script will create Access tables and file can be saved as MDB file.

Comments from generated SQL file:

'=======================================================
'=== Microsoft Access 2000/2002/2003 database creation method
'===
'=== 1. Create a new database in the Microsoft Access
'=== 2. Create a new module
'=== 3. Copy the TDM3 output SQL script into the new Microsoft Access module
'=== 4. Select from main menu "Tools" item "References..." and check
'=== the "Microsoft ActiveX Data Objects 2.x Library"
'=== and "Microsoft ADO Ext. 2.x for DDL and Security"
'=== and "Microsoft DAO 3.6 Object Library"
'=== 5. Place your mouse cursor somewhere in the main procedure Main()
'=== 6. Run the module code (Click the "Run Sub/UserForm" button or press F5)
'=======================================================

Additional notes:

Step 2 - can be opened via Alt+F11 keys
Step 3 - code can be inserted by selecting the down arrow from next Insert Module icon on the toolbar
Step 6 - use the Green Arrow icon on the toolbar

To see tables save database and module and then switch back to Access by selecting “View MS Access” icon