UtterAccess Discussion Forums > Linking Oracle tables to Access without the schema prefix

Full Version: Linking Oracle tables to Access without the schema prefix

UtterAccess Discussion Forums > Microsoft® Access > Access Automation

mdphilly

Nov 23 2004, 11:46 AM

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

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.