i****i
发帖数: 43 | 1 别人发过来一个Access 文件,他用的是Access2003, 我用的是Access 2007. 在打开里
面的queries时,出现:not a valid path error. 当我按右键design view 打开时,出
现的是SQL.我是Access新手,请各位高手指点.谢谢. | i****a
发帖数: 36252 | 2 post the sql here
【在 i****i 的大作中提到】
: 别人发过来一个Access 文件,他用的是Access2003, 我用的是Access 2007. 在打开里
: 面的queries时,出现:not a valid path error. 当我按右键design view 打开时,出
: 现的是SQL.我是Access新手,请各位高手指点.谢谢.
| i****i
发帖数: 43 | 3 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 | i****i
发帖数: 43 | 4 如果双击这个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
. | i****a
发帖数: 36252 | 5 query looks fine from a brief look
can you browse the linked tables? check linked table setting to make sure
they are valid
resides
【在 i****i 的大作中提到】
: 如果双击这个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
: .
| i****i
发帖数: 43 | 6 How check the linked table setting? | i****a
发帖数: 36252 | 7 in "tables", there is either linked table manager, or right click on the
linked table and say properties
going from memory...
【在 i****i 的大作中提到】
: How check the linked table setting?
| i****i
发帖数: 43 | 8 问题好像解决了。我重新link tables, 生成了MAS1, 然后我把SQL中的MAS改为MAS1，
RUN， 好像ok 了。谢谢IMAJIA。 | i****a
发帖数: 36252 | 9 it's better to fix the original linked table, cause other queries may
still be using that.
right click on the linked table, and say "linked table manager"
，
【在 i****i 的大作中提到】
: 问题好像解决了。我重新link tables, 生成了MAS1, 然后我把SQL中的MAS改为MAS1，
: RUN， 好像ok 了。谢谢IMAJIA。
| i****i
发帖数: 43 | 10 Yes, I have fixed the original linked table. Now everything is going well.
Does this problem relate to Access 2003 and Access 2007 conflicts? |
|
