Finding Orphan Objects

[DreamGenius]

I've created and tested a (simple) database tool that allows staff to amend a couple of Oracle tables but keep backups, change history and blame trail.

This is my first Access project, having gone straight from MS Query to MS SQL Server - I'm know learning how powerful Access can be and how much time it could have saved me!

Is there an easy way of finding the orphan objects in my database, so that they can be deleted? I don't want to break all my development!

Thanks in advance

 

[WayneRyan]

Dream,

Yes, I remember the ORACLE tables. You could traverse them and see
all fields in use by all of the forms in an application. A few queries would
show you what forms contained (or didn't contain a particular field).

In Access, you can traverse the Forms/Reports/Tables collections. It is
nowhere as convenient as the ORACLE environment, but you can glean
some info from it.

If you have any specific requirements, post back.

Wayne

 

[DreamGenius]

What do you mean by orphan objects? Queries/forms/reports/subs/etc. that you don't reference from any menu or other object?

That's exactly what I meant.