I want to change a field name in a table in MS Access from C++/MFC. There's no direct way
to do this in Visual Studio (RENAME in ALTER TABLE doesn't work when running in
MDB), but it's easy in VB.
The Automation library contains classes (_Application, IDoCmd, Module, etc.) that may
allow changing table field names. However, there's no documentation or information
available online.
Does anyone know of a direct way to do this, or perhaps by creating and calling an MDB
module procedure?