Build recordset of filtered table names?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access03/WinXp

I was wondering if it is possible to define a recordset of a specific set of
tables in a database, rather than all tables in the database collection.

I have a procedure that runs through all tables and if the table name begins
with a ZZ_ then it clears the data (they're temp tables). I thought it might
be faster, for the fractions of a second it may be worth, if I could filter
the list of tables to those beginning with ZZ_, rather than processing the
entire database collection and checking the table name.

Suggestions/comments?

Thanks.
 
use a query. start with

SELECT Name
FROM MSysObjects
WHERE MSysObjects.Type=6

alter to suit...
hth
 
Sorry, I forgot to clarify. The database is split and the temp tables are in
the FE; the SQL you provided results in only those tables linked to the BE.
What is the object name (instead of MSysObjects) for the user-defined objects
in the FE?

Thanks again.
 
Back
Top