How do you change the owner on linked tables when the original owner does not exist?? I tried the Linked-Table mangager and get an error that the Microsoft Jet engine could not find the object ‘owner_tablename’.
More info:
I have an access database that is made up of close to a hundred linked tables to an Oracle database and many queries, forms, macros, & reports. The owner of the tables when they were linked was owner1. So, my linked tables look like owner1_tablename.
I am trying touse the same database against another Oracle database that has the same table names but where the original owner does not exist.
Is there an easy way to do this? I really don’t want to have to relink all of those tables and rebuild all of the queries, etc.
Thanks
