Results 1 to 4 of 4

Thread: What's Wrong "Select"

  1. Jan 25th, 2004, 01:56 PM #1
    mhipate
    mhipate is offline

    Thread Starter
    Member
    Join Date
    Jan 2004
    Location
    Tampa, Fl
    Posts
    39

    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
    Reply With Quote Reply With Quote
  2. Jan 25th, 2004, 02:01 PM #2
    axion_sa
    axion_sa is offline
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724
    Perhaps "ACT" is a reserved keyword? What DBMS are you using?
    Reply With Quote Reply With Quote
  3. Jan 25th, 2004, 02:06 PM #3
    mhipate
    mhipate is offline

    Thread Starter
    Member
    Join Date
    Jan 2004
    Location
    Tampa, Fl
    Posts
    39
    I am using access2000
    ACT is used in another project and I have no problem
    Reply With Quote Reply With Quote
  4. Jan 25th, 2004, 04:58 PM #4
    randem
    randem is offline
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385
    mhipate

    Use

    "SELECT * from ACT Order by [TITLE]"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width