Searching for Tables Within MDB Files on Windows XP

[Guest]

I'm wondering if there is a way to perform a search, whether through Windows
or some script, to find a certain table name within a MDB file.

Ie) Want to search for a table name Area_Budget located in a database out on
a network drive, but unsure of path.

thanks in advance for any assistance.

-Stacey

 

[Guest]

Hi Stacey,

Although it's a rather large download (51.2 MB), the Access 2003 Conversion
Toolkit will allow you to perform this search. You can download a copy from
here:

http://www.microsoft.com/downloads/...76-5D89-450A-B977-980A9841111E&displaylang=en

You can specify a path to search, including all subfolders. When you perform
the search, make sure to have the option "DAO Properties" checked. When you
are finished with your search, you can create a new query based on the
tblTables table. Use your tablename, Area_Budget, as a criteria for the
query. Here is the correct SQL statement (ie. View > SQL View, when in query
design view):

SELECT tblTables.TableName, tblDatabases.DatabaseName,
tblDatabases.Path
FROM tblDatabases
INNER JOIN tblTables
ON tblDatabases.DatabaseID = tblTables.DatabaseID
WHERE (((tblTables.TableName)="Area_Budget"));

Note that the path returned is the short path designation, for example:
C:\DOCUME~1\tgw7078\MYDOCU~1\Access\

You can copy this path and paste it into the Find files dialog.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

So only the search has to be completed, not the analysis?

 

[Guest]

You need to complete the analysis of the DAO Properties.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________