Could someone Please tell me what's wrong, I get
Syntax error in from clause.
rs.Open "SELECT * from ACT Order by TITLE "
Thanks
Printable View
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]"