HELP I renamed a table and now my back-end links are screwed up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had to temporarily rename a table and now I cannot re-establish my back end links. It keeps wanting to point to the renamed name
Please help me, I have to roll out this system tomorrow AM and its hoplessly screwed up now.
 
If I understand your question.
While in database window view from the menu bar select file - get external
data - link tables.
This should allow you to reselect the table you want to link to regardless
of their name.

Mike

David said:
I had to temporarily rename a table and now I cannot re-establish my back
Click to expand...
end links. It keeps wanting to point to the renamed name.
Please help me, I have to roll out this system tomorrow AM and its
Click to expand...
hoplessly screwed up now.
 
I had to temporarily rename a table and now I cannot re-establish my back end links. It keeps wanting to point to the renamed name.
Please help me, I have to roll out this system tomorrow AM and its hoplessly screwed up now.
Click to expand...

Did you rename it in the backend or in the frontend?

In either case, you should be able to back up both databases (which
would, of course, have been a good idea a little while ago... :-{( );
delete the table from the frontend; and use File... Get External
Data... Link to create a completely new link to the backend.
Presumably you will have renamed the table back to its original name.

I'd strongly suggest turning off Name Autocorrect in both front and
backends first! It's supposed to help but often does more harm than
good.
 
Back
Top