|These routines serve the same function as the older version described below. This set is build for Access 2000 and uses ActiveX Data Objects (ADO) rather than Data Access Objects (DAO). For more detail, see: Steve Goodhall’s Connection Routines for Access 2000|
|Access Security Test Bed||
The files in this distribution are a test bed for
automated application of Microsoft Access Security.
After the application is run, the target databases will be secured so that:
|ODBC Access to an Excel Workbook||
This archive contains a demonstration of the use of ODBC and ADODB to read an Excel workbook.
This example is implemented using Excel, but the coding techniques can be used in Word or Access
Included files are:
ODBCSource.xls - source of date
ODBCCode.xls - code example
readme.txt - description of demonstration
|Test Referential Integrity for Optional Fields||
This database has been updated to incorporate the response to another thread on
the Access Developer listserv about creating relationships with program code.
This database is posted as part of the response to a thread on the Access Developer listserv about using Referential Integrity on Foreign Keys where a null value is permitted in the referencing table.
|Access Table Connection Routines||
These routines dynamically connect Back End Tables to a Front End database
containing Forms, Reports, Modules, etc.
|Access Version Control Routines||
These routines support automatic updating of a Front End (Code Only) database.
|Test Image Control||This database is posted here for a person on the Access Developer listserv who tried my suggestion about displaying blobs (specifically images) and could not get it to work.|
|Test Correlated Subquery||This database is posted as part of the response to a thread on the Access Developer listserv about grouping TOP n rows by a foreign key using correlated subqueries.|