可以在這裏問個Access問題嗎?緊急求助!!!

來源: 2011-06-07 09:44:16 [舊帖] [給我悄悄話] 本文已被閱讀:

別人發過來一個Access 文件,他用的是Access2003, 我用的是Access 2007. 在打開裏
麵的queries時,出現:not a valid path error.  當我按右鍵design view 打開時,出
現的是SQL.

這是SQL:SELECT MAS.PARCEL, MAS.Use, MAS.MRKT, MAS.CONST_YR, MAS.SQFT, MAS.FCVsf, MAS
.Sale_Year, MAS.Sale_Amt, MAS.[SalesPrice/sf], MAS.Legal1, MAS.CurrentLmt,
MAS.FCV, MAS.PriorFCV, MAS.Mail1, MAS.LANDFCV, MAS.CLS, MAS.Q, MAS.IMPFCV_SF
, MAS.[FCV%Change], MAS.[SqFt%Change], MAS.Acres, MAS.ParcelAddress, MAS.
MailZip, MAS.FCV_ADJ
FROM MAS;

MAS 是一個linked table

如果雙擊這個query,出現的是

'........' is not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file resides