Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    Dacula, GA, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query cannot be saved (Access 2002)

    When I try to save a query (the query returns the correct information when run), i.e. from Northwind sample database, I get the following dialog box with a yellow triangle with the exclamation point: "The search key was not found in any record."

    The query cannot be saved. When I click on the help button, nothing appears in the help pane.

    What does this message mean? How do I get around it.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query cannot be saved (Access 2002)

    1. How are you trying to save the query?

    2. Post the SQL of the query so we can see what it actually does.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    Dacula, GA, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query cannot be saved (Access 2002)

    Charlotte:
    Nothing fancy. Just close the query after it has run. The Save As dialogue appears. I give the query a name and say save. Then the error/warning message box appears. Here is the sql for the query. It runs fine from the menu. This query uses the Employees table and the Orders table from the Northwind example database.

    SELECT [LastName] & ", " & [FirstName] AS Rep, Orders.OrderDate, Orders.OrderID, Orders.ShipCountry, Orders.ShipName
    FROM Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID;

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query cannot be saved (Access 2002)

    Are you actually in the Northwind database? Is the database perchance read-only?
    Charlotte

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Query cannot be saved (Access 2002)

    Are you using Access security? I had similar problem with secured databases after installing Jet 4.0 Service Pack 5 (SP5). MS Knowledge Base Article Q301474 describes problem and possible fix IF you are using WIN 2K. Resolution for those NOT using WIN 2K is not provided. Since I'm still using WIN 98 had to resort to usual "fix": importing everything into a new, unsecured database & then reapplying security. Note the article references A2K not 2002 (I'm using A2K) but this is only explanation I've seen for this error.
    HTH

  6. #6
    New Lounger
    Join Date
    Apr 2001
    Location
    Dacula, GA, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query cannot be saved (Access 2002)

    Mark,
    Thanks, I loaded SP2 and the problem has gone away.

Posting Permissions

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