<div>
<div class="content wysiwyg-content">
How would I go about renaming a table that is on a SQL Server from my VBA code running in Access 2007.<br />
<br />
For example: <br />
I want to rename the table &quot;Commitment_Outlook_new&quot; to &quot;Commitment_Outlook&quot;<br />
Note: I DO NOT want to rename the link to the table but the actual table on SQL Server.
</div>
</div>


How would I go about renaming a table that is on a SQL Server from my VBA code running in Access 2007.

For example: 
I want to rename the table "Commitment_Outlook_new" to "Commitment_Outlook"
Note: I DO NOT want to rename the link to the table but the actual table on SQL Server.

Rename a SQL Server Table from my Access code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.