Re: Access changes the characters '(', ')' into '[' and '].' .
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 22 Sep 2006 13:20:18 -0400
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.
--
Ken Snell
<MS ACCESS MVP>
"SriM" <SriM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46ED4246-3364-4B2E-820D-691E60C59170@xxxxxxxxxxxxxxxx
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 .....].
.
- Prev by Date: Re: Query doesnt work after importing from 97 to 2000
- Next by Date: RE: Query failing with convert date critieria
- Previous by thread: interest calculations
- Next by thread: Moving data to tabular format from list table
- Index(es):
Relevant Pages
|
