>>Hello Group,
>>
>>I have a large database with a lot of tables, views, remote views, and connections. What risk is there in changing the name from CATC to BACC. Seems in the past when I tried that I got messages that table mytable belongs to CATC database.
>>
>
>Each table in the database has back link to DBC stored in it's header. If you rename DBC tables back links would still point to the old name and cause the message you described. To rename DBC properly, open the project, go to Data tab, find DBC, right-click on it and select rename. This way bacl links will be updated also.
Hi Sergey,
On Friday I had a similar problem. I had a table, which belonged to one DBC. I needed to add it to another DBC and preserve captions, comments, etc. (the fields were only 10 chars long fortunately). We had problems with Internet for couple of hours, so I could not ask advice here. After few unsuccessful attempts, I freed the table, added it to the right database and recreated captions and comments manually. Do you know a better way of doing such operation?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog