Re: How can I rename a database table?

From:

"Tom Serface" <tom.nospam@camaswood.com>

Newsgroups:

microsoft.public.vc.mfc

Date:

Tue, 12 Feb 2008 07:54:17 -0800

Message-ID:

<40057E7E-2A10-49AB-B372-FF011A04BEAC@microsoft.com>

You may want to ask this in an SQL group, but perhaps you'll have to write a
stored procedure to do this sort of thing and it could be that the queries
you do through the MFC interface are more restricted. I don't do much of
that for sure, but I thought I'd offer up the suggestion.

Tom

<mark.tootell@talk21.com> wrote in message
news:cc9c5fa1-433a-46b0-a26c-a2e5bf636040@z17g2000hsg.googlegroups.com...

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