Page 1 of 1

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

Posted: Sun Feb 26, 2017 10:02 pm
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.)