Alter table syntax for Access 2000

[steve]

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

 

[Cor Ligthert [MVP]]

Steve,

I think that this are some great links for you

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp

I hope this helps a little bit?

Cor

 

[Paul Clement]

¤ 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)