| [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]转自[/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]详细内容：http://www.office-cn.net/forum.php?mod=viewthread&tid=67854 |
|站长邮箱|小黑屋|手机版|Office中国/Access中国
( 粤ICP备10043721号-1 )
GMT+8, 2025-4-2 12:12 , Processed in 0.057079 second(s), 17 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.
