| [b][size=2][color=blue]用查詢語句獲取外部文件的對象[/color][/size][/b] [b][size=2][color=#0000ff][/color][/size][/b] [size=2][color=blue][color=#000000][b]作 者[/b]:[/color][url=http://www.accessoft.com/blog/?userid=563][color=#800080]葉雨欣的爸爸[/color][/url] [color=#000000][b]轉(zhuǎn)自[/b]:Access之家論壇（ [url=http://accesshome.5d6d.com]http://accesshome.5d6d.com[/url]）[/color][/color][/size][size=2][/size] [size=2][color=blue][hide]Select MsysObjects.Name AS ObjectName, MsysObjects.DateUpdate, IIf([type]=1 or [type]=6,"Table","Query") AS ObjectType FROM MsysObjects in 'C:\MAS.mdb' Where (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1) AND ((MsysObjects.Flags)=2097152 or (MsysObjects.Flags)=128 or (MsysObjects.Flags)=0 or (MsysObjects.Flags)=16)) orDER BY MsysObjects.Name; [/hide][/color][/size]詳細(xì)內(nèi)容：http://m.mzhfr.cn/forum.php?mod=viewthread&tid=67854 |
|站長郵箱|小黑屋|手機(jī)版|Office中國/Access中國
( 粵ICP備10043721號-1 )
GMT+8, 2025-7-13 08:43 , Processed in 0.072754 second(s), 16 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.
