Default for quote marks

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

Guest

Hi,

The default behaviour for Access if you type text in as a criteria for a
field is for double quote marks to be added around the text. I would like to
change this default behaviour so that it is single quote marks instead.

I am trying to have it so that the SQL produced by Access can be copied and
pasted into SQL Server and run without change required but double quote marks
is not standard for text criteria. Can I change Access' behaviour to make
the SQL transferable without changes?

TIA,

Rob
 
Hi,

The default behaviour for Access if you type text in as a criteria for a
field is for double quote marks to be added around the text. I would like to
change this default behaviour so that it is single quote marks instead.

I am trying to have it so that the SQL produced by Access can be copied and
pasted into SQL Server and run without change required but double quote marks
is not standard for text criteria. Can I change Access' behaviour to make
the SQL transferable without changes?

TIA,

Rob
Click to expand...

In A2003 (I'm not certain about earlier versions), select Tools...
Options... Tables/Queries and check SQL Server Compatible Syntax.

John W. Vinson[MVP]
 
Back
Top