Hi there , can anyone tell me how I can rename an access
table trough oledb.
I always get an error.
I've tried
Dim strSQL As String
Dim m_conn As New ADODB.Connection
Set m_conn = New ADODB.Connection
m_conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Players.mdb;Persist Security Info=False"

m_conn.CursorLocation = adUseClient
m_conn.Open 'CardPlay
strSQL = "RENAME OLDPLAYER TO NewPlayer"
m_conn.Execute strSQL
Set m_conn = Nothing

error raised:Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

i've tried some other statements but all raising error
of error in sql statement;
Can anyone help me with a right statement?