How to tell which objects are being used in my application. (1 Viewer)

[slharman1]

I have a front end DB that is 13,040 KB in size. I can no longer make an ACCDE compiled version to distribution. I have emptied and bunch of irrelevant tables (linked) but have a ton of queries not being used that I would like to be able to delete but I need to know if there is a way to determine if each object is being used or not.
Can someone guide me in the correct direction.
Thanks

 

[Gasman]

I would not thought that would be the issue?
Does it compile?

 

[slharman1]

Yes it will compile but when I try to make the ACCDE file I get "Microsoft Access was unable to create the accde file"
This is what shows up in the onscreen help file:
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).

 

[slharman1]

I would not thought that would be the issue?
Does it compile?

And this:
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.

 

[Pat Hartman]

One good tool that can help is Total Access Analyzer by www.fmsinc.com

I don't think it will find querydef references in VBA though. So, you know your own style. Let TAA tell you what querydefs are not referenced by queries, macros, forms, reports. Then you can just delete (backup first of course) the unused querydefs and test carefully. If you find any querydefs you still need, copy them back in. OR, if the list is short, you can just search the whole VBA project for the querydef names OR even simpler, search for the execute commands and compare the query name to your list of unused querydefs.

 

[GPGeorge]

The only thing I would do different from Pat might be that I'd rename potentially unused queries rather than delete them immediately. Later, when experience validated they are not used, I would make a second pass and delete them.

 

[slharman1]

One good tool that can help is Total Access Analyzer by www.fmsinc.com

I don't think it will find querydef references in VBA though. So, you know your own style. Let TAA tell you what querydefs are not referenced by queries, macros, forms, reports. Then you can just delete (backup first of course) the unused querydefs and test carefully. If you find any querydefs you still need, copy them back in. OR, if the list is short, you can just search the whole VBA project for the querydef names OR even simpler, search for the execute commands and compare the query name to your list of unused querydefs.

Thanks Pat - TAA is my Total Visual Agent for backing up - correct?

 

[Pat Hartman]

No, that would be TVA. TAA is Total Access Analyzer.

 

[GPGeorge]

Nope. They are two different products.

 

[slharman1]

No, that would be TVA. TAA is Total Access Analyzer.

Do you know if i have TAA, I thought all I have is TVA

 

[Pat Hartman]

How would I know if you have TAA? I'm pretty sure if you sign into your FMS account you'll see what you can download.

 

[LarryE]

I have a front end DB that is 13,040 KB in size. I can no longer make an ACCDE compiled version to distribution. I have emptied and bunch of irrelevant tables (linked) but have a ton of queries not being used that I would like to be able to delete but I need to know if there is a way to determine if each object is being used or not.
Can someone guide me in the correct direction.
Thanks

Database Tools>Object Dependencies shows this information for each object selected.

 

[slharman1]

How would I know if you have TAA? I'm pretty sure if you sign into your FMS account you'll see what you can download.

Holy Crap!, I have a lot to learn about TAA any pointers you can give? (just got it installed)

 

[GPGeorge]

Usually, the best place to get information about a vendor application is the vendor's documentation.

 

[slharman1]

OK So i just found out that access is creating the ACCDE file even though it is reporting it didn't during the saveas process.
That's a strange one to me.

 

[MajP]

I have not tried each but there is also

GitHub - strive4peace/Analyzer: The Analyzer, which runs in Microsoft Access, documents databases, is menu-driven, easy to use, and generates valuable information for developers and users with databases such as Access, and anything Access can connect

The Analyzer, which runs in Microsoft Access, documents databases, is menu-driven, easy to use, and generates valuable information for developers and users with databases such as Access, and anythi...

github.com

@strive4peace
and

Database Analyzer Pro

The professional version of this utility allows you to quickly analyze the contents of any Access database. Features include view and analyze database objects, object metadata and get object sizes. You can view table data and table design. Also view table fields and field properties. View query...

www.isladogs.co.uk

@isladogs
Each is free or has a free version.

 

[isladogs]

There are also the built-in Access tools: Object Dependency and Database Documenter
Which tool is most appropriate to your requirements will depend on the level of detail you need and your budget.

 

[Galaxiom]

There are also the built-in Access tools: Object Dependency and Database Documenter

Object Dependency doesn't find everything in my expereince but I have not used it for more than a casual check on tables and queries for a very long time.
I'm a big fan of VTools Total Search which I have always found reliable.

 

[KitaYama]

I'm a big fan of VTools Total Search which I have always found reliable.

Does VTools searches if functions are used in queries or forms' textboxes as event procedures?
I have a bitter experience with "Review Quality" in MZ_Tools. It showed some functions as dead code and are not used anywhere. I deleted them and later I found out they've been used in queries. And some of them where used in reports' textboxes control source or form's textboxes' property sheet.

thanks.

 

[isladogs]

As I previously said, the best tool(s) to use depend on the level of detail required and the user’s budget.
Object dependency doesn’t search modules or macros and has some other limitations. I agree that V-Tools is excellent. It searches all objects. However I believe V-Tools is 32-bit only.