
		*********************************
		*   Record Source Documentor	*
		*	ver 1.0 -- May 2004	*
		*	Eric R. Den Braber	*
		*	mr_ericdb@yahoo.com	*
		*********************************


Ever inherit an MDB file and wonder which tables, queries,
forms or reports were *really* used in the program?


Purpose
----------------
Inspect each form and report in a MDB file and
identify the corresponding record source for that object.


Expected Output
----------------
Each form or report will display one of the following record source options:
-INVALID RECORDSOURCE 	(refers to a table or query which does NOT exist)
-MISSING RECORDSOURCE 	(no record source listed for this object)
-SQL STATEMENT 		(lists the SQL behind the RecordSource)
-VALID 			(this table or query exists in the database)


Words of Caution
----------------
Of course, just because a form or report has no listed record source,
does NOT mean that it isn't used by the system. This utility is meant
to be a starting place to sift through a MDB file, nothing replaces human
judgment.

I provided no capacity to navigate MS Access Security (MDW). I did not 
account for anything beyond a simple password.


Requirements
----------------
MS Access 2000 or newer to open the utility. It will work on ACC97 MDB files.
References to MS Excel & DAO 3.6
(To set a reference: Open the VBA window (ALT+F11) --> Tools --> References)


Etc.
----------------
This utility is freely available to all and may not be sold.
Find any bugs or just want to drop me some feedback: mr_ericdb@yahoo.com



>>>>> Fixed DB so it will run in Access 2000 by changing reference to Excel 11 and changing it to Excel 9, and removing  the WindowMode:= command.  It seems to run fine now. 
Jim Coon, liteways@tir.com  
