How to search for all *.mdb files on a drive

[lukea51]

Does anyone know of any VB that will search a drive/drives for all *.mdb files and store there file locations in a table?

So far I have a ms access database that will compact all the databases that I have stored in a table, I'm just trying to find a way to import all the *.mdb files so I don't have to manually enter there locations into a table.

 

[ChrisO]

G’day lukea51.

The attachment should do as you require. It’s in Access 97 but converts to A2K3 okay.

Regards,
Chris.

 

[lukea51]

Thanks chris

 

[dallr]

Hey Chris whats up? Didn't realize that you were at this neck of the woods?

Dane aka. Dallr

 

[ChrisO]

G’day Dane.

Yep, a few of us move between forums on a regular basis, even UA can get a bit quite at times.

Regards,
Chris.

 

[dallr]

I hear you!, I only recently joined and just pop in and out when I have nothing to do. I wouldn't be spending to much time there though.

dane