Access 執行 SQL 時拋出「至少一個參數沒有被指定值」 (Error 3061),最常見原因非參數缺失,而是 欄位名稱拼寫錯誤 或 JOIN 語法不支援。本文整理兩大核心成因與解決對策。
Access 若在 SQL 找不到對應欄位,會將其視為「參數」並要求提供值。常見情況:
SELECT Order Date FROM Orders → 應為 SELECT [Order Date] FROM Orders。User_ID vs User_ID (全形底線)。SELECT ID AS UserID, UserID FROM T → 歧義。排查法:在 Access 查詢設計檢視逐一核對欄位清單,或在 SQL 檢視滑鼠懸停欄位名查看是否識別。
Access (Jet/ACE) 對 JOIN 括號嚴格要求:
SELECT * FROM (A LEFT JOIN B ON A.id=B.id) LEFT JOIN C ON B.id=C.idON (B.id=C.id AND B.type=C.type)-- 兩表
SELECT * FROM (Table1 AS A LEFT JOIN Table2 AS B ON A.ID = B.ID)
-- 三表 (巢狀括號)
SELECT * FROM ((Table1 AS A LEFT JOIN Table2 AS B ON A.ID = B.ID)
LEFT JOIN Table3 AS C ON B.ID = C.ID)
-- 多條件 ON
SELECT * FROM (A LEFT JOIN B ON A.ID=B.ID) LEFT JOIN C ON (B.ID=C.ID AND B.Code=C.Code)
SELECT * FROM Table1, Table2 WHERE Table1.ID = Table2.ID AND Table1.UserID = 'A00001'
簡單等值聯結可用此寫法繞過 JOIN 括號限制,但語意較不明確。
[...]?PARAMETERS?逐項排查以上清單,99% 的「參數未指定值」錯誤可在分鐘內解決。