How to rename a Table and Not to loose the relations

[javiernews via AccessMonster.com]

Hi,
How can I rename a Table and Not to loose the releations ???

I use the following code:
DoCmd.Rename strNewName, acTable, strOldName

Thank you !

 

[Alex Dybenko]

Hi,
if you mean that you do not see relation in relationships window - then
click on "show all relationships" there - and you will see it.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[David H]

In the OPTIONS dialog under the GENERAL tab is an option to turn on 'Name
Auto Correct', which *should* take care of propagating any name changes
throughout the database.

I would however make a backup first.

Also, I've read some posts about Name Correct occasionally causing problems
when its turned on. I don't remember specifically what the issues were as I
personally never use it, however you may want to google around just to be
aware of any possible issues.

 

[javiernews via AccessMonster.com]

Thank you David & Alex , for yours answers but,.........

Yes ofcourse I can make it manually every time,.....(pressing the button
'show all relationships' )
but,.......... How to make it automatically (may by code)
Is this possible ????

 

[David H]

When NAME AUTO CORRECT is turned on, Access should automatically update any
instance where the object is referenced to the new name - including the
relationships. In short, turn NAC on and when you rename the table, Access
will handle automatically updating the relationships.

Make a copy of the database and then in the copy turn NAC on and change the
table name, you should see that the relationships are then preserved.

http://msdn.microsoft.com/en-us/library/aa139941(office.10).aspx
http://office.microsoft.com/en-us/access/HA010345661033.aspx

I did find this article which should make you aware of the issues
surrounding NAC
http://allenbrowne.com/bug-03.html

 

[javiernews via AccessMonster.com]

Thank you David

Also a good answer here:
http://www.accessmonster.com/Uwe/Forum.aspx/access/31688/Relationships-don-t-show