Reserved Error (-1517) There is no message for this error

[Dorian]

"Reserved Error (-1517) There is no message for this error"

This is the message that I get when I run a query. This query used to work
and has not been modified. I did update the data in the columns this query
returns. Some of the columns contain slashes. Could this be a problem?
Here is the query, nothing esoteric:

SELECT ID, ReferralSource
FROM tblReferralSource
WHERE ActiveSW = true
ORDER BY ReferralSource;

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Jerry Whittle]

That's a very simple query so shouldn't be a problem. Try -1 instead of true.

Other than that, I'm thinking that there might be a database corruption
problem. Try opening a new database and importing everything from the old to
the new. Do the table and query in question first and see if they work. If
so, hopefully the import fixed them. If they won't even import, then there's
little doubt that the database is corrupt. I'm assuming that this is an
Access table and not something like a linked SQL server table or even an
Excel spreadsheet.

You might also want to create a new query with the same fields and criteria.
See if that will run.

 

[Dorian]

I put [ ] around the column containing the slashes and it started working.....
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Jerry Whittle]

Interesting.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I put [ ] around the column containing the slashes and it started working.....
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

That's a very simple query so shouldn't be a problem. Try -1 instead of true.

Other than that, I'm thinking that there might be a database corruption
problem. Try opening a new database and importing everything from the old to
the new. Do the table and query in question first and see if they work. If
so, hopefully the import fixed them. If they won't even import, then there's
little doubt that the database is corrupt. I'm assuming that this is an
Access table and not something like a linked SQL server table or even an
Excel spreadsheet.

You might also want to create a new query with the same fields and criteria.
See if that will run.