Microsoft Access and SQL Users HELP!!!

Discussion in 'OT Technology' started by cheet, Aug 17, 2004.

  1. cheet

    cheet OT Supporter

    Joined:
    Mar 22, 2004
    Messages:
    13,235
    Likes Received:
    3
    Location:
    CA
    I have a MS Access project with 5 tables in it. They all have a primary key and I established relationships between them. However, making a Form never works. Whenever I try to run the form I get error "Syntax error in FROM clause". I am not using any reserved words or characters in my Table or Field names...can anyone explain why this is happening and how to fix it?
     
  2. Scoob_13

    Scoob_13 Anything is possible, but the odds are astronomica

    Joined:
    Oct 5, 2001
    Messages:
    73,788
    Likes Received:
    38
    Location:
    Fort Worth. Hooray cowgirls.
    Can you post the query or queries that you're using on the form?
     
  3. cheet

    cheet OT Supporter

    Joined:
    Mar 22, 2004
    Messages:
    13,235
    Likes Received:
    3
    Location:
    CA
    I'm doing this all inside of Access itself, so I don't know of anyway to view the SQL of my forms it self. Is there a way?
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Well to exclude anything wrong with the form, make a query that the form is based on first. Once you've done that, at the top left of the query design window is a dropdown box that says datasheet view, design view and SQL view.
     

Share This Page