Select TableName

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Select TableName

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 11 Oct 2007 15:00 GMT

Hi

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

TIA
Barry

Reply to this Message

PvdG42 - 11 Oct 2007 16:35 GMT

> Hi
>
[quoted text clipped - 3 lines]
> 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*";

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...