Tips for using SQL statements to find out if a table exists in Access _access

The Access database, though a single feature, is indeed a small, lean development partner, and I met it in several projects to find out the source of the Access database, and today I went online for some information. The summary is summarized as follows:

It is really difficult to find a table in an Access database with an SQL statement. Fortunately, access itself has some hidden data objects can save your library information, today I encountered to use SQL, through the program to query whether a table exists problems, the solution is as follows:
Because the Administrators group of the Access database itself does not have permission to access suppressed objects, you first: Tools-> options-> view-> hidden objects, system objects, and previous tick selections.

The tool then-> Security-> User and group permissions, selects msysobjects in the object name (I only use this object, if I need something else, I can select it), and then set the Read Data permission in the permissions.

Finally, save the settings, in the program, you can query the table through the SQL statement, the statement is as follows:

SELECT Count (*) as Rtab from Msysobjects WHERE ((msysobjects.name) like "known table name to be judged");

Return 1 is present, 0 is not present
System environment: Win2000 Access2000