Audit of Access Databases

[winshent]

I need to conduct an audit of all the access databases that exist in the company i have just joined. According to my list we have 600+ !!

I have built a list of all files on the shared drives, so can filter by .mdb and .accdb extensions..

We have a number of different versions from 97 - 2007.

I need to extract linked table connection info for each database.

How can i do this?

How can i adapt the code in this link to extract table connection info?

http://www.access-programmers.co.uk/forums/showthread.php?t=184967&highlight=open+external+databases

typically using set db = currentdb I would iterate thru all the tabledefs.. but how can i do this with external db's

Also, will i be able to run it against db's created with previous versions.

 

[namliam]

If you look at the help for Currentdb you will find this:

Dim dbsCurrent As Database, dbsContacts As Database
Set dbsCurrent = CurrentDb
Set dbsContacts = DBEngine.Workspaces(0).OpenDatabase("Contacts.mdb")

guess that would be a way to open another database?!!

 

[winshent]

thanks.. that should help..