Double Quote in Access Query result Causes two double Quote When You copy and Paste.

[mamin123]

Hi
I Have access query result where i see expected result in MS access itself but when I copy and paste same result, I see extra double quote in result. how do I fix this issue ? Please see attached.

This is how I see query result in my MS Access query result

Catalog_Table_View
Statement
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": DELETE;
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": INSERT;
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": SELECT;
catalog sql object "_SYS_AFL"."EML_MODEL_CONFIGURATION": UPDATE;
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": DELETE;
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": INSERT;
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": SELECT;
catalog sql object "_SYS_AFL"."FUNCTION_EXECUTION_COUNTS_CONTROL": UPDATE;
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": DELETE;
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": INSERT;
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": SELECT;
catalog sql object "_SYS_AFL"."PLUGIN_ERRORS": UPDATE;
catalog sql object "_SYS_TASK"."CURRENT_VERSIONS_": SELECT;
catalog sql object "_SYS_XB"."MESSAGING_DESTINATIONS": SELECT;
catalog sql object "_SYS_XB"."MESSAGING_SUBSCRIPTIONS": SELECT;
catalog sql object "SYS"."EXPLAIN_PLAN_TABLE": DELETE;

<tbody>
</tbody>

When I copy and paste same result into any Text Editor (eg. Notepad), I see one extra double quote than I should be.

Example Query giving this result:
SELECT Unique_Privileges.*, "catalog sql object """ & Trim([SCHEMA_NAME]) & """.""" & Trim([OBJECT_NAME]) & """: " & Trim([PRIVILEGE]) & ";" AS Statement
FROM Unique_Privileges WHERE (((Unique_Privileges.OBJECT_TYPE)="TABLE" Or (Unique_Privileges.OBJECT_TYPE)="VIEW"));

"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": DELETE;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": INSERT;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": SELECT;"
"catalog sql object ""_SYS_AFL"".""EML_MODEL_CONFIGURATION"": UPDATE;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": DELETE;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": INSERT;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": SELECT;"
"catalog sql object ""_SYS_AFL"".""FUNCTION_EXECUTION_COUNTS_CONTROL"": UPDATE;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": DELETE;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": INSERT;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": SELECT;"
"catalog sql object ""_SYS_AFL"".""PLUGIN_ERRORS"": UPDATE;"
"catalog sql object ""_SYS_TASK"".""CURRENT_VERSIONS_"": SELECT;"
"catalog sql object ""_SYS_XB"".""MESSAGING_DESTINATIONS"": SELECT;"
"catalog sql object ""_SYS_XB"".""MESSAGING_SUBSCRIPTIONS"": SELECT;"
"catalog sql object ""SYS"".""EXPLAIN_PLAN_TABLE"": DELETE;"
"catalog sql object ""SYS"".""EXPLAIN_PLAN_TABLE"": SELECT;"
"catalog sql object ""SYS"".""FULL_SYSTEM_INFO_DUMPS"": SELECT;"

 

[xenou]

This query has extra quotes being provided in the query itself:
Example Query giving this result:
SELECT Unique_Privileges.*, "catalog sql object """ & Trim([SCHEMA_NAME]) & """.""" & Trim([OBJECT_NAME]) & """: " & Trim([PRIVILEGE]) & ";" AS Statement
FROM Unique_Privileges WHERE (((Unique_Privileges.OBJECT_TYPE)="TABLE" Or (Unique_Privileges.OBJECT_TYPE)="VIEW"));

 

[mamin123]

This query has extra quotes being provided in the query itself:
Example Query giving this result:
SELECT Unique_Privileges.*, "catalog sql object """ & Trim([SCHEMA_NAME]) & """.""" & Trim([OBJECT_NAME]) & """: " & Trim([PRIVILEGE]) & ";" AS Statement
FROM Unique_Privileges WHERE (((Unique_Privileges.OBJECT_TYPE)="TABLE" Or (Unique_Privileges.OBJECT_TYPE)="VIEW"));

Is there anyway I can avoid this situation ? May be write query differently ?

 

[xenou]

You could try removing the duplicate quotes in the query:

SELECT Unique_Privileges.*, "catalog sql object "  & Trim([SCHEMA_NAME]) & "." & Trim([OBJECT_NAME]) & ": " & Trim([PRIVILEGE]) & ";" AS Statement
FROM Unique_Privileges WHERE (((Unique_Privileges.OBJECT_TYPE)="TABLE" Or (Unique_Privileges.OBJECT_TYPE)="VIEW"));