I know this is an Excel forum but I don't know where else to ask this.

We have a database that has been used for quite a few years. Over the years, this guy or that guy created tables and/or queries.

I'm now tasked with trying to clean it up. Is there a way to find tables and/or queries that are not dependent on the others? I know there's a lot of tables and queries that I can delete but don't really want to unless I know if they're connected to other stuff.

Thanks

• Edited by TurkR 19 hours 8 minutes ago

Hi,

You can check the relationships between tables/queries in an Access database.

Click Database tools>Relationships.

More reference:

http://support.microsoft.com/kb/304466/en-us

Regards,

George Zhao
TechNet Community Support

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 2 hours 27 minutes ago