Rename mdb column

Question

Hello

I use Access Database Engine and OleDbReader to work with mdb and accdb files, need to rename a column:

"ALTER TABLE xc RENAME Column old new LONG"

Searched and found ADE might not support it, what if I add a new column and drop the old one?

But the new one will be added to end of tables, need to be in the place of old one.

Anyway using ADE?

Thanks

Answer 1

Hi @StewartBW ,

The SQL syntax ALTER TABLE xc RENAME COLUMN old TO new is not supported directly by Access SQL.

If the column order is crucial for your application, and you absolutely need the new column to be in the same position as the old one, you'll need to:

1. Create a new table with the desired column order.
2. Copy the data from the old table to the new table.
3. Drop the old table.
4. Rename the new table to the original table name.

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.