MsysObjects 值的含义 -32758、-32757 和 3 (Microsoft Access)

问题描述

我正在查询表 MsysObjects 以制作我的数据库中的对象列表:

I'm quering the table MsysObjects for making a list of the objects in my database:

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

我知道这个值的含义:

-32768 = Form
-32766 = Macro
-32764 = Report
-32761 = Module
1 = Table
5 = Query
6 = Linked Table

但是 -32758、-32757 和 3 呢?他们代表什么?网上找不到.

But what about -32758, -32757 and 3? Where do they stand for? Cannot find it on the web.

推荐答案

Type   TypeDesc
-32768  Form
-32766  Macro
-32764  Reports
-32761  Module
-32758  Users
-32757  Database Document
-32756  Data Access Pages
1   Table - Local Access Tables
2   Access Object - Database
3   Access Object - Containers
4   Table - Linked ODBC Tables
5   Queries
6   Table - Linked Access Tables
8   SubDataSheets

-- http://www.access-programmers.co.uk/forums/showthread.php?t=103811

这篇关于MsysObjects 值的含义 -32758、-32757 和 3 (Microsoft Access)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！