推薦：解決Access中分組報(bào)表的問(wèn)題
在Word中，大家對(duì)段落的對(duì)齊方式、縮進(jìn)、段前、段后間距等屬性都比較熟悉，但是，你是否注意到段落的另外一個(gè)非常重要的屬性——大綱級(jí)別（如圖1）。 實(shí)際上，段落的大綱級(jí)別在

使用下列 SQL 語(yǔ)句來(lái)獲取你想要的

查詢：

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)=5 ORDER BY MSysObjects.Name;

窗體：

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;

表：

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;

報(bào)表：

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name;

模塊：

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32761 ORDER BY MSysObjects.Name;

宏：

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32766 ORDER BY MSysObjects.Name;

分享：破解Access的密碼
在mdb文件第0x42字節(jié)處的13個(gè)字節(jié)分別與0x86,0xfb,0xec,0x37,0x5d,0x44,0x9c,0xfa,0xc6,0x5e,0x28,0xe6,0x13異或后即可得到數(shù)據(jù)庫(kù)的密碼。但在Access 2000和2002的版本里密鑰不再是固定的13個(gè)字