single &double quotes in identifiers (table & field names)

General usage of Access to MySQL

Moderator: jr

Koy
Posts: 2
Joined: Sun Feb 26, 2017 9:42 pm

single &double quotes in identifiers (table & field names)

Post by Koy »

Access does allow table names and field names to have single and double quotes in them. But they don't work very well in SQL.

I suggest having an option to filter them out, or at a minimum flagging them before the conversion process starts so that the user can remove them in Access before proceeding.

In the past I had Access table names like this:

Sharon's costs

And Access field names like this:

len' -for length in feet
len" - for length in inches

(This was nice because it kept field names short. Much better than len-inches or len-in or len(i) or iLen.)