可以在这里问个Access问题吗？紧急求助！！！

别人发过来一个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

 

所有跟帖： 

• 你检查一下path呀。 -小谋- ♀ (0 bytes) () 06/07/2011 postreply 09:49:42

• I think this has something to do with the linked table. Check th -dukect- ♀ (0 bytes) () 06/07/2011 postreply 10:18:37

• whith linked table. Check the path of it -dukect- ♀ (0 bytes) () 06/07/2011 postreply 10:19:41

• 回复：可以在这里问个Access问题吗？紧急求助！！！ -mylittlehome- ♀ (443 bytes) () 06/07/2011 postreply 10:36:08

• 回复：回复：可以在这里问个Access问题吗？紧急求助！！！ -ilpipi- ♀ (55 bytes) () 06/07/2011 postreply 10:39:25

• 回复：可以在这里问个Access问题吗？紧急求助！！！ -ilpipi- ♀ (61 bytes) () 06/07/2011 postreply 10:38:10