Where Oh Where Has My Database Gone?

[davegri]

Does your computer have a lot of database files scattered across its filing system? Different versions of the same DB in separate locations? If so, which is the latest version? Have you ever tried to locate a database that contains a specific table, but you can't remember the DB name or where it is? Would you like to have a list of all the .mde files in your computer, reported by folder location? Are there any .accdt files on your computer?


This utility DB will answer these questions easily, as well as expediting many otherwise laborious manual searches. It's practically AI !!


FYI, you can easily design additional reports as query qExtended contains complete breakout of fields:
Full Path with filename
Full Path without filename
filename
file extension
date changed attribute

DBFinder-v01.zip

[isladogs]

Hi Dave
I like this - similar to the excellent Everything utility but specific to database files
The searches are very fast as well.

I'd like to adapt this and publish it as a free example app on my website ... providing that's OK with you.
I would of course give full credit to you for the idea and the code I use

Perhaps discuss this further via PM/email?

Two issues
a) I got repeated error 53 in AddToCollection - file not found which doesn't make sense to me
b) I also got error 3075 in ListFiles with a badly named client file containing an apostrophe

For now, I've added error handling to deal with those and will investigate further later

I notice that it won't work if you use a root folder such as G:\ which is a pity.
I haven't investigated why as yet. Can this easily be overcome or is it a limitation of the code used?

Finally, out of interest what are .mdz files? Never heard of this suffix and its not listed in Windows settings for applications by file type

There are a few other obscure Access file types
e.g. .accdc (signed package), .accdw (Web app), .aacft (data type template), .mdn (blank database template), .mdbhtml (Access HTML document).
FWIW you can also have shortcuts to individual db objects (form/query/reports etc : .maf, .maq, mar etc

[Welshgasman]

Any chance of a 2007 compatible version please Dave?

[davegri]

Hi Dave
I like this - similar to the excellent Everything utility but specific to database files
The searches are very fast as well.

I'd like to adapt this and publish it as a free example app on my website ... providing that's OK with you.
I would of course give full credit to you for the idea and the code I use

Perhaps discuss this further via PM/email?

Colin, OK with me. I think the whole idea of posting sample databases is to provide a framework idea that can be used as is or modified in any way that an individual downloader sees fit. Many of the samples posted here vary in usefulness as is, but can be starters for working solutions. Feel free to adapt/extend the app as you like.

The .mdz file was (is) for creation of a custom wizard. I faintly remember trying that out years ago and it worked.

[davegri]

Any chance of a 2007 compatible version please Dave?

Sorry WGM, I don't have that version. Sample databases aren't necessarily 100% working apps for everyone, or backward compatible.

[alansidman]

@davegri
Very slick. Thanks

Alan