设为首页收藏本站Access中国

Office中国论坛/Access中国论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

快速获取外部文件对象名的简单方法

2009-1-10 11:26| 发布者: huangqinyong| 查看: 6591| 评论: 10

[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
发表评论

最新评论

查看全部评论(10)

相关分类

QQ|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )  

GMT+8, 2024-3-29 01:39 , Processed in 0.069603 second(s), 16 queries .

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

返回顶部