Renaming MS Access columns...

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.

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:\test\test\\app_data\test.mdb");
DAO.Field fld = db.TableDefs[tableName].Fields[oldFieldName];
fld.Name = newFieldName; db.Close();

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

I do write this code but its doesnt work. Some help please: