Project:	vbDatabaseCoder Add-In
Copyright:	 1999-2000 qbd software ltd
Author:		edward moth

Date:		25 june 2001
Author:		Hans van der Pluijm (hans@pluijm.net)
Changes:	Added support for multiple-field indexes
		Added support for reading Access2000 databases

=====================================================================

PLEASE READ THE BORING WARRANTY AND LICENSE INFORMATION - FAILURE TO
DO SO WILL DEEM YOU 'A BIT NAUGHTY' UNDER THE PROVISIONS OF SECTION
118.12(A) OF THE PROTECTION OF EDWARD MOTH ACT (1999) - HM GOVERNMENT
(UNITED KINGDOM) PLEASE ALSO NOTE THAT UNDER SECTION 112.3 OF SAID
ACT, ALL PAYMENTS TO EDWARD SHOULD BE MADE IN CASH IN BROWN ENVELOPES - BET NO ONE READS THIS - HEHEHE - THEY NEVER DO.

=====================================================================

A.	PURPOSE
B.	REQUIREMENTS
C.	HOW TO SET UP THE PROJECT FOR USE AS AN ADD-IN
D.	HOW TO USE THE ADD-IN
E.	WARRANTY AND LICENSE
F.	CONTACT

=====================================================================

A PURPOSE:

DatabaseCoder is a VB Add-in that will analyse an Access97 database
and make the code in VB required to create an empty replica of the
database from scratch.  It does not copy records, it only creates the
structure.  You can view the information the add-in has retrieved
from the database,  Tables, Fields, Indexes and Relationships.

25-june-2001: addendum
	Access 2000 Database supported (See requirements)
	Access 97 database will be created.

=====================================================================

B REQUIREMENTS:

It's kinda handy if you have a copy of Visual Basic (version 5 or 6).
MS Access 97 may also prove to be a useful addition although
technically not essential

The Project uses:
	MS Common Dialog (v.6.00.8169)
	MS Windows Common Controls 5 (v.6.00.8022)
	MS DAO 3.51 Object Library

The program was written in VB5 (Service Pack 3)

ASSUMES:	The walls have ears
RETURNS:	Only with valid receipt signed by edward moth

25-june-2001: For Access 2000 use the following:
	VB6 (Service Pack 4)
	MS DAO 3.6 Object Library
=====================================================================

C HOW TO SET UP THE PROJECT FOR USE AS AN ADD-IN:

1.	Load the Project dbCoderAddIn.vbp
2.	In the immediate window type: AddToINI
3.	Select 'Make dbCoderAddIn.dll...' from the File menu
4.	Using the Add-In Manager, select 'qbd Database Coder'
5.	The Add-In will be available from the Add-Ins Menu
	(listed as 'VB Database Coder'

25-june-2001: Keep in mind that the database generated is in
	Access97 format. Creating Access2000 database is not possible
	when using DAO (3.6).
=====================================================================

D HOW TO USE THE ADD IN:

Start the Add-In from the Add-Ins menu.  Click the Open button.
Select an Access97/2000 database file (.mdb) and click Open.  The
database structure will appear in the left window.  Clicking on an
item will show the Attributes for that item in the right window.

Click the 'Insert Code' button.  The Code to create the database will
be put in the Active Project in a new Standard Module called
'mdbCreator' (if the module exists a procedure will be added to it).

Click exit.

You can create the database by adding the code:

bOkay = Database_Create(sFilename)

Where:

sFilename	is the path and name of the Database to be created
bOkay		is the return value (True - creation successful / 
		False - unsuccessful)

ASSUMES:	The database doesn't already exist
		Reference to DAO 3.5x Object Library exists

RETURNS:	True if successful
		False if unsuccessful
		
=====================================================================

E BLAH ... THE BORING BITS

WARRANTIES:
All code is provided 'as is', without warranties of any kind whatsoever
no matter who you say your dad is, even if it is expressed or implied
(the warranties that is, not your dad).

LIABILTY:
qbd software ltd and edward moth accept no liability whatsoever even
if you or your partner get up the duff.  By using this code you accept
that Manchester United are the greatest football team of all time
(okay ... if you're not happy with that, I'll let you off).

LICENSE:
You are free to use and modify any of the code but it would be nice
if you left references to qbd software limited, qbd and edward moth in
place :-) obviously if you nick it and make out it's your own coding
the management and employees of qbd software ltd will be forced to
take serious retaliatory action such as tuttting loudly and calling
you names behind your back.

You can freely distribute the zip and the code but give us credit
(Amex Platinum for preference but 'Thanx to edward moth and qbd
software ltd' would suffice).  If you wish to contant us then please
see the instructions below.

=====================================================================

F CONTACT US:

If you wish to contact edward moth or qbd software then
please follow these instructions:

Categorise your mail:

Mail Type One:	
		* Begging Letters
		* Spam
		* Complaint
		* Abusive
		* Marriage proposal
		* Advertising
		* Porn related
		* Pyramid selling
		* Stupid
		* Contains a virus (we particularly dislike common colds)
		* Contains blank lines because you sent it before you
		  had written it
		* To brag about how much better you are a PSX games
		  than edward (highly unlikely)
		
	or - 	* If you have any contagious medical condition
		* You have an obsession that encompasses your whole life
		* You are William Hague MP

	Send your Mail to: 	trash@qbdsoftware.co.uk
				It will be treated with the utmost
				respect and dealt with promptly

Mail Type Two:

		* Praise
		* Contracts for Tender
		* Job offers (minimum salaries apply - make sure it's
		  good or we'll laugh)
		* Funny
		* Worth reading
		* Exciting Ideas that will make us rich (and that does
		  not include selling perfume)

	or:	* You are Bill Gates regarding 'those share options'
		* You are edward's mom
			

	Send your Mail to:	edward@qbdsoftware.co.uk


