Re: How can I rename a database table?

Hi

I am working on a project that uses the MFC CDatabase and CRecordset
classes to handle its interfacing with an Access database. It is
necessary for the software to rename a table within existing user
databases to ensure that they are valid for use with the new version
of the software.

As a result of my limited database and MFC knowledge I am having
difficulty finding a way of renaming the table. I have tried using the
following:

try
{
   theDataBase.ExecuteSQL( "RENAME oldTableName TO newTableName");
}
catch( CDBException* e)
{
  e->m_strError;
}

However, it results in the following error:
"Invalid SQL statement; Expected 'Delete', 'Insert', 'Procedure',
'Select', or 'Update'."

I have also tried:

SQLExecDirect( theDataBase.m_hdbc, ... , SQL_NTS);

But at compile time I am told that m_hdbc is protected and therefore
cannot be used in this way even though MSDN suggests that I can!?
Can anyone suggest a way of renaming this table programmatically?

Thanks