[AccessD] Search MDBs for specific table name

Hi Mark,

1) Walk through the files in the folder using a collection of files

2) Try to import the object(s) you're looking for from each mdb.  If you
don't get an error, the object exists.  (I've never tried this)

You can probably use this example from Help: 
    DoCmd.TransferDatabase acImport, "Microsoft Access", _
    "C:\My Documents\NWSales.mdb", acReport, "NW Sales for April", _
    "Corporate Sales for April"

3) Store the name of the mdb's and objects in a table for later reference.

I want to know if you try this and if it works!

Good Luck,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Monday, March 24, 2008 3:29 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Search MDBs for specific table name


Hello All,

I need to search a folder with 100's of Access DBs...and find the ones with
a certain table,form,qry, or module name.  Any ideas?

Thanks,

Mark A. Matte



_________________________________________________________________
Watch "Cause Effect," a show about real people making a real difference.
Learn more.
http://im.live.com/Messenger/IM/MTV/?source=text_watchcause
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com