Both of the following formats should work:
SELECT HSK00023.Location, HSK00023.Oper, HSK00023.[Lot #], HSK00023.Qty, HSK00023.Comments, HSK00023.Gospod
FROM HSK00023
WHERE (((HSK00023.Location) Like "*" & "ABCDE" & "*"));
SELECT HSK00023.Location, HSK00023.Oper, HSK00023.[Lot #], HSK00023.Qty, HSK00023.Comments, HSK00023.Gospod
FROM HSK00023
WHERE (((HSK00023.Location) Like "*abcde*"));