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" <[email protected]>
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]

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

 

[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]

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

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