Select TableName

[Barry]

Hi

I want to populate a combobox with all table names in a MS Access database,
what will the sql string be?

TIA
Barry

 

[PvdG42]

Hi

I want to populate a combobox with all table names in a MS Access
database, what will the sql string be?

TIA
Barry

Here's a query that worked for me to return the tables I created in an
Access 2007 DB and exclude the system tables:

SELECT NAME
FROM MSysObjects
WHERE Type = 1 AND NAME NOT LIKE "MSys*";