Point and click queries.

            Any data source.

                        Any computer.

                                    Data server.

                                                Free.


              Microsoft Access
                ( Please scroll down. )

Disclaimer

Brand names are addressed only as a service to CoreReader users. See the source specifics page for details.

To add to these notes or to add your favorite data source, see instructions on the source specifics page.

Source

Ron Selby of Oklahoma City, OK.

Also, the CoreReader development environment includes production Access 97 and Access 2000 databases.

Running With Microsoft Access

CAUTION! A fact that is known only among experienced engineers is that Ms. Access is atrociously ill behaved. Among other astounding feats of which it is capable, I have witnessed it repeatedly crash a major corporation's enterprise level database server running on a remote machine.

Therefore, do not run Ms. Access when CoreReader is running. Ms. Access may lock up CoreReader. If that happens, unload Ms. Access, and CoreReader will sometimes resume where it was interrupted.

Sometime prior to release number 20921, Microsoft made a hidden change in their data sources. Whether it was part of their frenzied security repairs or more attempts to control the end user cannot be known. What is known is that any CoreReader releases before that date will not function with current Microsoft data sources.

Object names with embedded spaces are frowned upon in professional circles. However, many Ms. Access databases seem to have them. If your database has that problem, press the config button to open the configuration screen and configure CoreReader to accept illegal characters in names. ( See the configuration section of the documentation for details. )

Also, your tables should be keyed to allow joins.

CoreReader can load Ms. Access queries along with the tables. If you understand their nature and purpose, you can use this feature of CoreReader to emulate server views.

A database load will include any working tables such as temporary or deleted tables that access has not cleaned out of its work areas. Those will have strange looking names such as those with an umlaut prefix. CoreReader can be coerced to query them, but they are trash.

This web site is maintained with Notepad.

Copyright 2001 - 2010 John Ragan.