Alter table syntax for Access 2000

's Computer Specifications

Hi All

What is the sql syntax to alter a table name in Access 2000 using oledb and
VB net 2003

sql = "ALTER TABLE Base RENAME BaseTemp"

cmd.CommandText = sql

cmd.ExecuteNonQuery()

does not work (syntax error in Alter Table statement)

Regards

Steve

's Computer Specifications

Steve,

I think that this are some great links for you

http://msdn.microsoft.com/library/de.../acfundsql.asp

http://msdn.microsoft.com/library/de...l/acintsql.asp

http://msdn.microsoft.com/library/de...l/acadvsql.asp

I hope this helps a little bit?

Cor

's Computer Specifications

On Sun, 24 Jul 2005 12:09:57 +1000, "steve" <(E-Mail Removed)> wrote:

¤ Hi All
¤
¤ What is the sql syntax to alter a table name in Access 2000 using oledb and
¤ VB net 2003
¤
¤ sql = "ALTER TABLE Base RENAME BaseTemp"
¤
¤ cmd.CommandText = sql
¤
¤ cmd.ExecuteNonQuery()
¤
¤ does not work (syntax error in Alter Table statement)
¤

Access DDL doesn't support the ability to rename a table. You would need to use DAO or ADOX:

Paul
~~~~
Microsoft MVP (Visual Basic)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ALTER TABLE syntax?	manningfan@gmail.com	Microsoft Access Database Table Design	6	29th Jun 2006 04:36 PM
ALTER TABLE syntax	=?Utf-8?B?R1BP?=	Microsoft Access Queries	2	5th Jan 2005 01:13 AM
Help with ALTER Table syntax	Jake	Microsoft Access	4	2nd Sep 2004 12:53 PM
ALTER TABLE syntax	Tim Marsden	Microsoft Access	1	18th Feb 2004 12:57 PM
Constraint alter table problem ( Access 2000 )	Filip Courtheyn	Microsoft Access Database Table Design	1	12th Nov 2003 09:36 PM