This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C21C21.D240FF6E
Content-Type: text/plain;
	charset="iso-8859-1"

Cheers Nick
 
I'll look into it.
 
Thanks for your help
 
Nigel

-----Original Message-----
From: Nick McNair [mailto:Nick.McNair@A...]
Sent: Tuesday, June 25, 2002 9:26 AM
To: sql language
Subject: [sql_language] RE: T-SQL Statement to Rename Tables


Nigel,
    
    VBA is available in Access2000 which allows you to control virtually all
objects programatically.
    You can use VB with Access2000 - but I ain't the guy to ask!!
 
Nick

-----Original Message-----
From: Nigel Parker [mailto:Nigel.Parker@c...]
Sent: 25 June 2002 09:08
To: sql language
Subject: [sql_language] RE: T-SQL Statement to Rename Tables


HI Nick
 
Can this be done form within VB?
 
Nigel

-----Original Message-----
From: Nick McNair [mailto:Nick.McNair@A...]
Sent: Tuesday, June 25, 2002 9:10 AM
To: sql language
Subject: [sql_language] RE: T-SQL Statement to Rename Tables


Nigel,
    Yep - 
 
    To run the Rename action in Visual Basic, use the
<javascript:hhobj_3.Click()> Rename method of the
<javascript:hhobj_4.Click()> DoCmd object.
    Rename takes three arguments: New Name, Object Type (eg.acTable) and Old
Name.  You can't rename an open object
 
Nick 



 -----Original Message-----
From: Nigel Parker [mailto:Nigel.Parker@c...]
Sent: 25 June 2002 08:49
To: sql language
Subject: [sql_language] RE: T-SQL Statement to Rename Tables


Hi Nick
 
Is type of thing possible in Access 2000?
 
Nigel

-----Original Message-----
From: Nick McNair [mailto:Nick.McNair@A...]
Sent: Tuesday, June 25, 2002 8:50 AM
To: sql language
Subject: [sql_language] RE: T-SQL Statement to Rename Tables


Nigel,
 
    use sp_rename
 
    eg. sp_rename 'u' , 'v' will rename the object (table\sp\view) from u to
v.
 
    any stored procs or views that refer to the table will be broken.
 
Nick

-----Original Message-----
From: Nigel Parker [mailto:Nigel.Parker@c...]
Sent: 25 June 2002 08:40
To: sql language
Subject: [sql_language] T-SQL Statement to Rename Tables


Hi
I have a quick question.
Is it possible to rename tables using T-SQL in SQL 
server 7 / 2000.
 
I have tried the:
 
RENAME TABLE tablename TO newtablename
 
but it didn't work.
Any suggestions?
 
Nigel
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to  



*********************************************************************
This message and any attachments are confidential and should only be
read by those to whom they are addressed. If you are not the intended
recipient, please contact us, delete the message from your computer 
and destroy any copies. Any distribution or copying without our prior
permission is prohibited. 

The Achilles Group does not accept legal responsibility for the 
contents of this message. The recipient is responsible for verifying 
its authenticity before acting on the contents. Any views or opinions 
presented are solely those of the author and do not necessarily 
represent those of the Achilles Group.

This email has been scanned by MAILsweeper and Sophos Anti-Virus 
products. However, The Achilles Group will have no liability for any 
viruses contained in this email or any attachment with this email.
*********************************************************************
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to  

--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to  



*********************************************************************
This message and any attachments are confidential and should only be
read by those to whom they are addressed. If you are not the intended
recipient, please contact us, delete the message from your computer 
and destroy any copies. Any distribution or copying without our prior
permission is prohibited. 

The Achilles Group does not accept legal responsibility for the 
contents of this message. The recipient is responsible for verifying 
its authenticity before acting on the contents. Any views or opinions 
presented are solely those of the author and do not necessarily 
represent those of the Achilles Group.

This email has been scanned by MAILsweeper and Sophos Anti-Virus 
products. However, The Achilles Group will have no liability for any 
viruses contained in this email or any attachment with this email.
*********************************************************************
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to  

--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to  



*********************************************************************
This message and any attachments are confidential and should only be
read by those to whom they are addressed. If you are not the intended
recipient, please contact us, delete the message from your computer 
and destroy any copies. Any distribution or copying without our prior
permission is prohibited. 

The Achilles Group does not accept legal responsibility for the 
contents of this message. The recipient is responsible for verifying 
its authenticity before acting on the contents. Any views or opinions 
presented are solely those of the author and do not necessarily 
represent those of the Achilles Group.

This email has been scanned by MAILsweeper and Sophos Anti-Virus 
products. However, The Achilles Group will have no liability for any 
viruses contained in this email or any attachment with this email.
*********************************************************************
--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to