Way to check and see if this table is used any place before I delete it??

[TenOc]

I am a self-taught access user/programmer. My data base is about 10 years old and I have made many changes to it. I have one table that I am sure (?) is no longer used. Is there a way to check and see if this table is used any place before I delete it??

[isladogs]

Several ways such as
1. Use the built-in Object Dependencies feature - it doesn't check the code unfortunately but third party tools can do that as well.
2. Use the built-in Database Documenter. It provides a lot of info...probably more than you want.

Before deleting any object, I would turn off the Name Autocorrect feature then rename the object e.g. with a z or ~ as a prefix. It doesn't matter what but be consistent.
Leave it in place for a month or so until you are sure nothing got broken. After that, do a backup as a precaution then delete it

[ssanfu]

Maybe this will be of some help. I found this code many, many years ago and have made modifications for my requirements. It checks all database objects for the specified word.
Exctact the .bas file and import it into your dB. Goto MODULES and look at the code in the module "MDB Documenter"
Be sure and Edit the path to where you want the file to be saved

Open "C:\Documents and Settings\Tenoc\Desktop\WhereReferencedHBB.txt" For Output As #k

Usage

t = WhereReferenced("tblAIQ_Division", prn, k)

WhereReferenced = the name of the function
"tblAIQ_Division" = what you are searching for
prn = boo;ean for printer to text file. Shood leave TRUE
k = FreeFile - the next free handle for the text file