UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Linking Oracle tables to Access without the schema prefix    
 
   
mdphilly
post Nov 23 2004, 11:46 AM
Post #1

New Member
Posts: 6
From: Michigan, USA
I have an Access database that I was forced to link to an Oracle back-end. Currently when ever I make changes to the tables in Oracle, I have to re-link the tables and manually change the table names to exclude the schema.
example:
Oracle table name: MIKEP.CONTACT
Access table name: CONTACT

I would love to learn how to do this procedure in code. Is there anyone out there that has this problem or any suggestions?

Thanks,
Michael
Go to the top of the page
 
+
« Next Oldest · Access Automation · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 20th May 2013 - 07:10 AM