Searching database for name of table or parts thereof?

[FSPH]

Hi there,

I have about 50 tables in my Access database. As you can imagine, it can be
difficult to find specific tables. I would like to search all the tables for
a table name or parts thereof.

How can I do that? I looked for it, but could not come up with an approach.

Thank you for your help.

 

[Maury Markowitz]

I have about 50 tables in my Access database. As you can imagine, it can be
difficult to find specific tables. I would like to search all the tables for
a table name or parts thereof.

http://databases.aspfaq.com/database/how-do-i-get-a-list-of-access-tables-and-their-row-counts.html

Basically:

SELECT Name FROM MSysObjects
WHERE
(Left([Name],1)<>"~")
AND (Left([Name],4) <> "MSys")
AND ([Type] In (1, 4, 6))
AND [put your search here, like] name LIKE 'mytable%'

 

[FSPH]

Hi there,

thanks very much for the VBScript programming solution.

Is there really no built in functionality in Access? I am looking for a
command like "Search data tables" that I can click on........

I have about 50 tables in my Access database. As you can imagine, it can be
difficult to find specific tables. I would like to search all the tables for
a table name or parts thereof.

http://databases.aspfaq.com/database/how-do-i-get-a-list-of-access-tables-and-their-row-counts.html

Basically:

SELECT Name FROM MSysObjects
WHERE
(Left([Name],1)<>"~")
AND (Left([Name],4) <> "MSys")
AND ([Type] In (1, 4, 6))
AND [put your search here, like] name LIKE 'mytable%'

 

[Tom Wickerath]

Maury gave you a SQL statement (ie. a query), not VB script.

Access 2007 allows you to search for table names, but you'll need to get
used to working with the Navigation Pane (Pain).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________