Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Terrapin Nation

    Unanswered: Leveraging Oracle Synonym's

    Good morning,

    LEts say have an ORACLE table named "test" with columns, test1, test2, test3.

    I have an access database (more like 10 of them) that link to this test table that is in a production environment.

    If I rename the ORACLE table to "prod" and the columns prod1, prod2, prod3, is there a way to avoid having to relink the table but not have to change ever form, query and report recordsource to reflect the name changes?

    Last edited by TerpInMD; 01-17-06 at 11:45. Reason: sorry no delete button

  2. #2
    Join Date
    Sep 2004
    Charlotte, NC
    I would link to the new Prod table. I would delete the link to the Test table. I would then create a select query and call it Test (or whatever your table's original name was) and build it from the Prod table with the Prod fields renamed as Test fields as such:

    SELECT prod.prod1 AS test1, prod.prod2 AS test2, prod.prod3 AS test3
    FROM prod;

    All of your forms queries and reports should work fine pulling from this query without any changes.

    I hope this helps.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts