use ADOX for this :-)

2 Jul 2005 8:23 AM

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" <ord***@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

5 Jul 2005 7:45 PM

Paul Clement

On Sat, 2 Jul 2005 10:23:01 +0200, "m.posseth" <poss***@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)

5 Jul 2005 8:27 PM

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

Show quoteHide quote

"Paul Clement" <UseAdddressAtEndofMess***@swspectrum.com> wrote in message
news:ajolc11q22jgdjgn3nqmmp747g9po47fr7@4ax.com...
> On Sat, 2 Jul 2005 10:23:01 +0200, "m.posseth" <poss***@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)

6 Jul 2005 7:27 AM

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

6 Jul 2005 7:13 PM

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 ,,,,

Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:uK%230ZxfgFHA.2080@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
>

7 Jul 2005 6:53 AM

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

6 Jul 2005 2:39 PM

Paul Clement

On Tue, 5 Jul 2005 22:27:19 +0200, "m.posseth" <mich***@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)