Introduction

We would like to thank Shaun Wallace for his input into this project.

dbCoder analyses a Microsoft® Access Database and creates the code required to create a blank copy of the database.  This can either be copied to the clipboard or saved as a BAS module.

This was an in-house project that I wrote because I hated coding database creation routines.  I have redesigned the output file twice because people have contacted me to say that they get a 'Procedure > 64k' error so it now probably suits larger databases.

I test it using our own in-house databases and Northwind and Biblio but it is always difficult to test for every combination of database use and setting.  If you have any problems let me know.

What's New

The dbCoder Add-In has been removed from this release.

Version 1.3.4 (coded by Shaun Wallace)

1. Better handling of dates as default field values.

2. Explicitly use DAO to reference database objects

3. Specify "Option Explicit" at start of generated code

4. Some bug fixes (especially handling of strings)

5. Support added for Validation Rules/Text on tables and fields

6. Support added for AllowZeroLength property on fields

7. Support added for IgnoreNulls property on indexes

8. Clears clipboard before pasting code into it

9. Allow executable version to be resized / maximized etc

10. Updated tree structure to show new properties that are handled

11. Retrieves database version and uses this to create correct database version i.e. can now make Access 2000 database

12. Add Exclude KeepLocal so local tables and queries needn't be copied. (Report queries are set to keep local so these won't be copied anymore if Exclude option ticked)

13. Allow for KeepLocal property to be set if copied and include sub to set the KeepLocal property value

14. Bug fix on displaying relations in tree

15. Removed dbCoder Add-In project.

Note: With KeepLocal, if using it on a table that table's relations must also be local else errors will occur in replication and database creation. Also local relations can't enforce data integrity between normal and local tables.