Access changes the characters '(', ')' into '[' and '].' .

S

SriM

Access changes the characters '(', ')' into '[' and '].' respectively. How
to stop this from happening.

Everytime the query is opened for editing, the above characters are changed
and when tried to save, Access gives syntax error and need to revert those
changes before able to save.

Is there any setting in Access to stop this happening?

SELECT * FROM (SELECT .....) becomes as
SELECT * FROM [SELECT .....].
 
K

Ken Snell \(MVP\)

What you're seeing is the "normal" behavior of ACCESS/Jet. Jet needs the
[ ]. syntax when you use a SELECT statement as the source table in a table.
It's a pain, but I know of no way to prevent the change, which happens when
you close the query after editing.
 
Top