need help in macros and access DB with external oracle DB connectivity?

In existing Microsoft Access DataBase we have table that inputvalue mapped from oracle DB,I hope with help of macros its getting purged into the access DB from Oracle DB. here my question is there is anyway to identify the existing mapping be开发者_如何学编程tween oracle DB Field to Access DB Field? Please help on this.

---

Using VBA:

Dim fld As DAO.Field
Dim tdf As TableDef
Dim db As Database

    Set db = CurrentDb

    For Each tdf In db.TableDefs
        ''Linked table
        If Len(tdf.Connect) > 0 Then
            Debug.Print tdf.Connect
            ''Local name
            Debug.Print tdf.Name
            ''Source name
            Debug.Print tdf.SourceTableName

            For Each fld In tdf.Fields
               ''Local name
                Debug.Print fld.Name
               ''Source name
                Debug.Print fld.SourceField
            Next
        End If
    Next