Re: renaming a access table in ado .net
From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 02/14/05
- Next message: Erkan SEN: "Re: Default value of a Table in Sql server To default value in Dat"
- Previous message: Cor Ligthert: "Re: What's the best way to insert new records only"
- In reply to: ray well: "renaming a access table in ado .net"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Feb 2005 11:06:39 -0600
On Mon, 14 Feb 2005 08:57:06 -0500, "ray well" <nospam@nospam.com> wrote:
¤ 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 ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
- Next message: Erkan SEN: "Re: Default value of a Table in Sql server To default value in Dat"
- Previous message: Cor Ligthert: "Re: What's the best way to insert new records only"
- In reply to: ray well: "renaming a access table in ado .net"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
