[AccessD] Search multiple MDB/ACCDB files at once?

Bill Benson bensonforums at gmail.com
Mon Mar 28 15:17:20 CDT 2022


Arthur you can write vba code like

Set DBS = DBEngine(0).OpenDatabase strFullParh

Then loop containers, tabledefs, querydefs, etc. Probably can’t inspect VBA
Code

On Sat, Mar 26, 2022 at 11:51 AM Rocky Smolin <rockysmolin2 at gmail.com>
wrote:

> Why search the backups? Isn't there only one - the latest - version that
> you need to worry about?
>
> r
>
> On Sat, Mar 26, 2022 at 7:47 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > Is there some way (or tool) that can search multiple Access files at once
> > for the name of some object (form, query, report, table) by name?
> > The reason I ask is because in moving an app from 32- to 64-bit, for some
> > reason the migration is never quite complete, and I have no idea why. I
> > have numerous backups and never thought I'd say it, but the sheer number
> of
> > them is overwhelming. Searching them one by one could take all weekend.
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list