use ADOX for this :-)

[m.posseth]

yep ,,,, You can do this ( verry easy ) with ADOX

objADOXDatabase.Tables(oldName).Name = newName

As DDL is not yet implemented in ADO.NET MS recomends using ADOX to perform
DDL


Van: "johnb41" <or****@informatik.com>
Onderwerp: Re: Adding Columns to Jet/Access database
Datum: woensdag 29 juni 2005 17:10

I searched all 3 links, and there is no command for "Renaming" a table.
I searched the web, and SQL does have a Rename command. Is it not
available for Jet/Access?

Does anyone know how to rename a table in SQL for Jet/Access?

Thanks,
John

[Paul Clement]

On Sat, 2 Jul 2005 10:23:01 +0200, "m.posseth" <po*****@planet.nl> wrote:

¤
¤
¤ yep ,,,, You can do this ( verry easy ) with ADOX
¤
¤ objADOXDatabase.Tables(oldName).Name = newName
¤
¤ As DDL is not yet implemented in ADO.NET MS recomends using ADOX to perform
¤ DDL
¤

DDL is implemented through the database engine, not ADO.NET, and Access DDL doesn't support table
renaming.
Paul
~~~~
Microsoft MVP (Visual Basic)

[m.posseth]

Maybe i should have said ,,,, use ADOX for those actions you want to perform
on a Access database that you can`t do with ADO.Net
like creating a database or as in this situation renamming a table ,
altering / managing table schemas
.....or do you really believe that DAO is the prefered way ? ,,,,,

Michel


"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:aj********************************@4ax.com...

On Sat, 2 Jul 2005 10:23:01 +0200, "m.posseth" <po*****@planet.nl> wrote:

¤
¤
¤ yep ,,,, You can do this ( verry easy ) with ADOX
¤
¤ objADOXDatabase.Tables(oldName).Name = newName
¤
¤ As DDL is not yet implemented in ADO.NET MS recomends using ADOX to
perform
¤ DDL
¤

DDL is implemented through the database engine, not ADO.NET, and Access
DDL doesn't support table
renaming.
Paul
~~~~
Microsoft MVP (Visual Basic)

[Cor Ligthert [MVP]]

Michel,

I prefer this sequence ADONET ? not possible ADO ? not possible DOA ? not
possible than sent a message to the dotNet.Data newsgroup, maybe Paul can
help me than.

:-))

Cor

[Paul Clement]

On Tue, 5 Jul 2005 22:27:19 +0200, "m.posseth" <mi*****@nohausystems.nl> wrote:

¤
¤ Maybe i should have said ,,,, use ADOX for those actions you want to perform
¤ on a Access database that you can`t do with ADO.Net
¤ like creating a database or as in this situation renamming a table ,
¤ altering / managing table schemas
¤

That's fine. You could go one step further and suggest that DDL be used if the feature is supported
by the language. This way you're not dependent upon a specific object model such as DAO, ADO or even
ADO.NET.

In any event, I just wanted to make sure that people understood that the DDL language was not
specific to ADO.NET.

¤
¤ ....or do you really believe that DAO is the prefered way ? ,,,,,
No, although DAO is supported it isn't recommended for use in .NET because of its limited threading
model.
Paul
~~~~
Microsoft MVP (Visual Basic)

[m.posseth]

DOA ??? Death On Arrival :-) that`s even really true spoken when
someone would choose DAO

regards

And Congratulations Cor with your MVP status ,,,,
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uK****************@TK2MSFTNGP10.phx.gbl...

Michel,

I prefer this sequence ADONET ? not possible ADO ? not possible DOA ? not
possible than sent a message to the dotNet.Data newsgroup, maybe Paul can
help me than.

:-))

Cor

[Cor Ligthert [MVP]]

Michel,

DOA ??? Death On Arrival :-) that`s even really true spoken when
someone would choose DAO

regards

And Congratulations Cor with your MVP status ,,,,

LOL, although I cannot say I do not do that, in this case I surely did not
do it express, however assume that it will be more used now.

In addition thanks,

Cor