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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 .....].
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Query design view - commas being changed to pipe characters 4
access 2003/2007 - problems with unwanted pipe character 0
Pipe character in query in VB6 app 11
Trim in Query Error 1
Help with a partial match query 6
Export to excel has character limit 3
Syntax Error in From Clause 2

Back
Top