Renaming MS Access columns...

Question

Hi!

I need to rename some MS Access columns name.
I have a table with three columns: name, link in, link out. What I need is to rename link in and link out to link_in and link_out.
In other way it's an update... But I need to learn how it's possible to do it with simple c# code.

Thanx,
Israel.

Israel · Answer

I will review it step by step...

Vulpes · Answer

I've just tried it myself but the code builds fine 'as is'. It doesn't even need a 'using' directive as DAO is a 'top level' namespace. Are you sure you've added the reference to the Microsoft DAO 3.6 Object Library correctly? It's under the COM tab in the Add Reference dialog.

Israel · Answer

I do try that liink but there is a bug on "DAO". I do add this reference Microsoft.office.interop.access.dao. But the bug still on DAO. // test data string tableName = "Members"; string oldFieldName = "Photo" ; string newFieldName = "Photograph" ; // COM Reference required in C# project: // Microsoft DAO 3.6 Object Library // var dbe = new DAO . DBEngine (); DAO . Database db = dbe . OpenDatabase ( @"C:	est	est\app_data	est.mdb" ); DAO . Field fld = db . TableDefs [ tableName ]. Fields [ oldFieldName ]; fld . Name = newFieldName ; db . Close ();

Vulpes · Answer

If you mean that you want to change the names of columns in the Access DB table itself, as opposed to the names of the columns in the DataTable generated by a SQL query, then check out this SO thread for how to do it from C#: http://stackoverflow.com/questions/23074935/rename-a-column-in-ms-access-dynamically-using-c-sharp

Israel · Answer

I do write this code but its doesnt work. Some help please: OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:	est	est\app_data	est.mdb;Persist Security Info=False"); con.Open(); DataTable table = new DataTable(); table.Columns.Add(" name ", typeof(string)); table.Columns[0].ColumnName = " name #"; table.Columns.Add(" link in ", typeof(string)); table.Columns[1].ColumnName = " link_in #"; table.Columns.Add(" link out ", typeof(string)); table.Columns[2].ColumnName = " link_out #"; conn.Close();