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.
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?