What's Wrong "Select"

Could someone Please tell me what's wrong, I get
Syntax error in from clause.

rs.Open "SELECT * from ACT Order by TITLE "


Thanks

Perhaps "ACT" is a reserved keyword? What DBMS are you using?

I am using access2000
ACT is used in another project and I have no problem

mhipate

Use

"SELECT * from ACT Order by [TITLE]"