ACC2: Attaching ORACLE Public Synonyms

MORE INFORMATION

1. Open any database.
2. From the View menu, choose Options.
3. In the Category box, select General.
4. In the Items box, set Show System Objects to Yes. You should now be able to attach your ORACLE public synonyms in the Attach Table list box. If you would like to attach objects using code, you can use the following piece of code.
   
   NOTE: In the following sample code, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when re-creating this code.
   

         Function AttachSynonym ()
         DoCmd TransferDatabase a_attach, "<SQL Database>", _
         "ODBC;", a_table,"PUBLIC.TESTSYN1", "Test_Syn"
         End Function
   
      Note that the function attaches a public synonym called TESTSYN1 as
      Test_Synon.