Default for quote marks

[Robert Chapman]

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

 

[John Vinson]

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

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

John W. Vinson[MVP]