Tables in use?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen - 27 May 2004 20:16 GMT

I'm looking for a way to know if a table is used in queries, forms, reports and macros
I'm using Access 2000

I've got more than 500 tables and more than 700 forms... very long job to check them one by one
I've got to do some cleaning and i don't know the application very well yet.

Reply to this Message

Kevin3NF - 27 May 2004 21:13 GMT

I have heard good things about:
http://www.fmsinc.com/products/access.asp

I have used and like:
http://www.moshannon.com/speedferret.html

Alternatively (and free):
Tools>>Analyze>>Documenter, select everything but the tables, run the
report, export to word, and CTRL-F

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

> I'm looking for a way to know if a table is used in queries, forms, reports and macros.
> I'm using Access 2000.
>
> I've got more than 500 tables and more than 700 forms... very long job to check them one by one.
> I've got to do some cleaning and i don't know the application very well yet.

Reply to this Message

pdm - 30 May 2004 21:31 GMT

I use the following for queries. I had another for code etc but didn't finish it. If you name all your queries on form/report controls and use only queries in code then it should probably do most of it

Public Function QryDepChk(sLikeText As String) As Boolea
'Finds queries with given subquery or table in the
'31/10/0
Dim qdf As DAO.QueryDe

Debug.Print "Query dependencies: queries containing '"; sLikeText; "'
Debug.Print "***********************************************
For Each qdf In CurrentDb.QueryDef
If qdf.SQL Like "*" & sLikeText & "*" And qdf.Name <> sLikeText Then Debug.Print qdf.Nam
Next qd
Set qdf = Nothin
End Function

Reply to this Message