How do I rename MSAccess tables in C#?

veggiemanuk · September 10th, 2005, 05:37 PM

Hi,

Im currently working on a project and I need to rename Access Table names programaticaly in C#.

Unlike SQL, Access does not have a sp_rename stored procedure, so how would I go about this in code for an Access db using an oledb connection?

Thanks in advance.

anubhav.kumar · October 2nd, 2005, 08:47 AM

hi,

well you can't do it directly through ADO.Net. This is an application level action and for this you have to add reference either to the ms access library or ado 2.8 (COM Interoperability) Then use ADOX Library to initiate ms access as an application inside your c# code and then you can send commands to it. refer to ado documentation for this. if you have ado installed on your system, search for "*.chm" files on your system starting with "ado".

cheers

Anubhav Kumar

veggiemanuk · October 8th, 2005, 10:47 AM

Thanks for the reply, thought that would be the case, is that still true for ADO.NET 2?

deepak.vasudevan · October 22nd, 2005, 09:03 AM

Quote:

quote:Originally posted by veggiemanuk
Thanks for the reply, thought that would be the case, is that still true for ADO.NET 2?

You may like to check out http://www.stpworks.com/ which gives a free Microsoft Access web-based administrator in ASP. That should solve your problem of renaming tables.

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/