Rename a field name using code with variables

[ineedahelp]

Hi, can anyone help me with the code necessary to rename a field in an access table. I have tried the ALTER TABLE method but it doesn't like my variable names. Here is the code and thank you for any help!
ALTER TABLE tblClientTable RENAME COLUMN fldRateField TO "MarketPric e"

[MMcCarthy]

Take the quotes of MarketPrice.

Hi, can anyone help me with the code necessary to rename a field in an access table. I have tried the ALTER TABLE method but it doesn't like my variable names. Here is the code and thank you for any help!
ALTER TABLE tblClientTable RENAME COLUMN fldRateField TO "MarketPric e"

[ineedahelp]

I took the quotes off MarketPrice, but I still get a compile/syntax error and my variable tblClientTable seems to be the problem. Could it be that I haven't declared this variable properly?

Dim fldRateField As String
Dim tblClientTable As String
fldRateField = Forms!frmDailyC lient!lstFieldL ist
tblClientTable = Forms!frmDailyC lient!lstTableL ist
ALTER TABLE tblClientTable RENAME COLUMN fldRateField TO MarketPrice

Thank you for any additional help!

[MMcCarthy]

Try:

Dim fldRateField As Field
Dim tblClientTable As Table

I took the quotes off MarketPrice, but I still get a compile/syntax error and my variable tblClientTable seems to be the problem. Could it be that I haven't declared this variable properly?

Dim fldRateField As String
Dim tblClientTable As String
fldRateField = Forms!frmDailyC lient!lstFieldL ist
tblClientTable = Forms!frmDailyC lient!lstTableL ist
ALTER TABLE tblClientTable RENAME COLUMN fldRateField TO MarketPrice

Thank you for any additional help!