rename a table of an access file (.mdb) using oledb

[aydinozdemir]

how can i rename an access table?
i know how to delete but need to rename it..
cmd = New OleDbCommand("DROP TABLE " + TABLE, con)
thanks for any suggestion.

 

[JuggaloBrotha]

ALTER TABLE <table name> RENAME TO <new table name>

How Rename a Table in SQL Statment that Contain Data?