Query cannot be saved (Access 2002)

Topic

New Reply

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.

Reply | Quote

Replies

1. How are you trying to save the query?

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

Reply | Quote

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;

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote