G Guest Feb 2, 2004 #1 I have an application that uses an Access db. I would like to be able to programmatically change the column names in one of the tables. I know how to get the Schema of the database but how can I change it?
I have an application that uses an Access db. I would like to be able to programmatically change the column names in one of the tables. I know how to get the Schema of the database but how can I change it?
M Miha Markic [MVP C#] Feb 2, 2004 #2 Hi Eric, You might use ADOX to manipulated the database structure. See this thread: http://tinyurl.com/2hy97 -- Miha Markic [MVP C#] - RightHand .NET consulting & software development miha at rthand com www.rthand.com Eric said: I have an application that uses an Access db. I would like to be able to Click to expand... programmatically change the column names in one of the tables. I know how to get the Schema of the database but how can I change it?
Hi Eric, You might use ADOX to manipulated the database structure. See this thread: http://tinyurl.com/2hy97 -- Miha Markic [MVP C#] - RightHand .NET consulting & software development miha at rthand com www.rthand.com Eric said: I have an application that uses an Access db. I would like to be able to Click to expand... programmatically change the column names in one of the tables. I know how to get the Schema of the database but how can I change it?
M Mike Collier Feb 2, 2004 #3 I have an application that uses an Access db. I would like to be able to programmatically change the column >names in one of the tables you can alos use SQL DDL statements ALTER, CREATE. http://81.130.213.94/myforum/forum_posts.asp?TID=64&PN=1
I have an application that uses an Access db. I would like to be able to programmatically change the column >names in one of the tables you can alos use SQL DDL statements ALTER, CREATE. http://81.130.213.94/myforum/forum_posts.asp?TID=64&PN=1
