Refreshing after SQL Select Sort

I get this nasty message: Run-time error '3450': Syntax error in query. Incomplete query clause.
after clicking the cmdSort database button. Here's what the code looks like:

Private Sub cmdSort_Click()
datClients(1).RecordSource = "SELECT * FROM 'Client Info' ORDER BY 'Name' ASC"
datClients(1).Refresh
End Sub

but the debugger is saying there's a problem with the "datClients(1).refresh" line

help !

First Try
"SELECT * FROM 'Client Info' ORDER BY Name ASC"
Then Try
"SELECT * FROM [Client Info] ORDER BY Name ASC"

I'm pretty sure that the SQL engine thinks that 'Name' is a value, not a field name.
I'm not so sure about 'Client Info', but it is probably the same problem.

Good Luck,
Brian



Brian T. Wiehoff