Linking Tables from Microsoft Access
In an Access Database - Create a new table
choose to link to files of type ODBC database
choose Machine Datasource - of d0db
Login to database (this takes a few moments because we seem to allow ALL the tables, including the system ones to be visible - will fix this)
choose a table (or tables) to link to and mirror locally
if you didn’t give it a primary key in oracle you will need to for Access
VOILA! the data is there locally - go to it - make reports, link to other data, whatever….