how to connect access & VB6. how to show contents of 1 field of a table in a field of another table, both fields having same name. what is ADODB how to use in code. thanks