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

D

David

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

Mike Revis

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

John W. Vinson

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top