Maybe many friends who are using Access have never opened Access's system built-in tables. This article can help you briefly understand the system's built-in tables.
program code
<%sqlcmd="select name from [msysobjects] where type=1 and flags=0"%>
You can use this statement to obtain all tables in the Access database, but you need to set the permission to read the MSysObjects table, otherwise the error message "Cannot read records; no permission to read data on 'MSysObjects'" will appear.
Office 2003 settings: Tools->Options->View->Check hidden objects and system objects. Tools->Security->User and Group Permissions, select MSysObjects in the object name, and then set its read permission in the permissions.
Office 2007 settings: Click the icon in the upper left corner -> Access options -> Current database -> Navigation -> Navigation options -> Check Show hidden objects to display system objects. Database Tools tab -> Users and Permissions -> User and Group Permissions, select the table as the object type, select MSysObjects as the object name, and then check the "Read Data" permission.
There is another way to read all tables in the Access database:
program code
<%
set rs=conn.openSchema(20)'returns a Recordset object containing schema information
rs.filter="table_type='table'"'Filters data tables whose table_type is table type, and other types are system built-in tables
do while not rs.eof
response.write(rs("TABLE_NAME"))' Use the recordset record set to obtain the data with the column name table_name
response.Write("<br />")
rs.movenext:loop
%>