renaming a access table in ado .net

  • Thread starter Thread starter ray well
  • Start date Start date
R

ray well

hi,

i need to rename a table in a access database, within ado .net.

is that doable with a ExecuteNonQuery sql command applied to a
OleDbConnection, if so what
would the command be, i can't find any documentation for it?

is it done thru a SchemaTable? what then would be code. i tried
SchemaTable.Rows(RowCount)!TABLE_NAME = "tblNewName", but it is read only.

thanks for any help

ray
 
¤ hi,
¤
¤ i need to rename a table in a access database, within ado .net.
¤
¤ is that doable with a ExecuteNonQuery sql command applied to a
¤ OleDbConnection, if so what
¤ would the command be, i can't find any documentation for it?
¤
¤ is it done thru a SchemaTable? what then would be code. i tried
¤ SchemaTable.Rows(RowCount)!TABLE_NAME = "tblNewName", but it is read only.
¤

I'm not aware of any way to rename a table directly using Access SQL DLL.

You will probably need to use either ADOX (Microsoft ADO 2.x for DDL and Security) or DAO.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top