Error 3075

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Mike N.

    #1

    Error 3075

    Hello-
    I have a normal application split into a frontend and backend. The
    tables are in the backend. All tables open correctly from the backend.
    When in the OBJECTS window (F11) in the front end, one table will not open
    in datasheet view. I get the error message 3075 "Syntax error (missing
    operator) in query expression 'sort sequence'" All other tables open
    correctly, and they are all linked correctly. All I do is click on "OPEN"
    in the OPEN - DESIGN - NEW area of the Objects window to get the error
    message. Any idea of what's happening?
    Thanks a lot...
    Mike from Moriches


  • Wayne Morgan

    #2
    Re: Error 3075

    In the front-end file, try deleting the table link and relinking that table.

    --
    Wayne Morgan
    MS Access MVP


    "Mike N." <MikeN451@opton line.net> wrote in message
    news:wWP5f.1513 $fn.225@fe08.lg a...[color=blue]
    > Hello-
    > I have a normal application split into a frontend and backend. The
    > tables are in the backend. All tables open correctly from the backend.
    > When in the OBJECTS window (F11) in the front end, one table will not
    > open in datasheet view. I get the error message 3075 "Syntax error
    > (missing operator) in query expression 'sort sequence'" All other tables
    > open correctly, and they are all linked correctly. All I do is click on
    > "OPEN" in the OPEN - DESIGN - NEW area of the Objects window to get the
    > error message. Any idea of what's happening?
    > Thanks a lot...
    > Mike from Moriches
    >[/color]


    Comment

    Working...