Is there a way to rename a table in and Access database? I was searching on the MSDN site for the SQL syntax for renaming a table. The closest thing I found was for Visual FoxPro, which read:
RENAME TABLE table_old TO table_new Unfortunately, the statement fails, with the error reading: DBD::ODBC::db do failed: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) at filename.pl line 981 Thanks in advance for the help. Brad Smith
