Relinking renamed tables in access to Oracle 8 backend using VBA code 1

[alaskaguru]

Thanks for trying to help. Here is what I have:<br>
<br>
Backend: Oracle 8.0.5 26 tables with views based on username<br>
Front end: Access 97 Links to those views which are then renamed to be user-friendly.<br>
<br>
I have 26 views built from 26 tables in the back end. When I modify a table in oracle then I have to re-link the view to it in access or I get the message &quot;This is not an updatable recordset&quot;. If I use the Linked Table Manager to relink it then I still get the same message. The manual says that I can't use the linked table manager if the names of the linked tables are changed--which is what I have done to make the table names more user-friendly. I have code to rename the tables but all of the code for linking the tables I have written (using the help files and manuals) has not worked. I can manually delete the linked tables and then manually relink them and everything works great--but I wouldn't want to have to talk a remote user through it over the phone. If anyone has some code for this could they pass it on? I'd appreciate it. The oracle views I'm linking to all have a &quot;v&quot; in their name as in &quot;vemployee&quot;. I am using an ODBC connection to the database.

 

[JimHorton]

(see my response in the Access forum...)