Bilbo_Baggins_Esq
Registered User.
- Local time
- Today, 05:44
- Joined
- Jul 5, 2007
- Messages
- 586
I'm not sure if "Audit" is the correct or best word, but does anybody know of a way to clean a database up?
I recently inherited a database for upgrade to x64 Access and a lot of it was just running DoCmd action queries in temporary tables.
It worked, but was very basic and very slow.
So I changed/updated it to run several of the processes in VBA a little more properly.
But now, there are a ton of unused queries and tables which I'm sure could be irradicated.
I can review the code I have replaced and list the items, but I can't be sure if they are used elsewhere unless I do a "find" within the project for each one.
I started that process, but it is very tedious.
Also, that sill won't tell me if any of the tables or select queries are used within other queries.
I'm wondering if there is some wiz-bang tool or code one can use to perform (for lack of a better word) an audit of the database, to list existing references to all the objects or functions?
I recently inherited a database for upgrade to x64 Access and a lot of it was just running DoCmd action queries in temporary tables.
It worked, but was very basic and very slow.
So I changed/updated it to run several of the processes in VBA a little more properly.
But now, there are a ton of unused queries and tables which I'm sure could be irradicated.
I can review the code I have replaced and list the items, but I can't be sure if they are used elsewhere unless I do a "find" within the project for each one.
I started that process, but it is very tedious.
Also, that sill won't tell me if any of the tables or select queries are used within other queries.
I'm wondering if there is some wiz-bang tool or code one can use to perform (for lack of a better word) an audit of the database, to list existing references to all the objects or functions?
