Forum Discussion

MarySmith2020

Copper Contributor

May 06, 2020

Solved

Table Alias in Access 2019

In Access 2016 and earlier, in a query, you can set an alias for a table by clicking on the table and showing the Property Sheet. This opened what used to be the "Field List Properties" with a "Gene...

access

George Hepworth
May 06, 2020
MarySmith2020 I found where it has been reported to the MS Access team at Microsoft and they are investigating it. I don't know when a fix will be available.

George Hepworth

Iron Contributor

May 06, 2020

MarySmith2020 This is a known bug introduced in a recent update. I'll verify if there's a fix and post back what I find.

MarySmith2020
Copper Contributor
May 06, 2020
George Hepworth That would be awesome! Well, you testing it... not that it is possibly a bug. 🙂
- George Hepworth
  Iron Contributor
  May 06, 2020
  MarySmith2020 I found where it has been reported to the MS Access team at Microsoft and they are investigating it. I don't know when a fix will be available.
  - MarySmith2020
    Copper Contributor
    May 06, 2020
    George Hepworth Thank you. At least you can get the query design window to take a brute-forced SQL alias and show it and use it in the QBE field list. How can something like this happen? I'm really surprised that I could not find mention of it in my google searches. Thanks again.