Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Find every instance a field or table is used.

I have an Access database that connects to a SQL server.  We are doing a ton of rewrites because of our external systems that have changed and they feed into this ordering database.

Is there a utility that will into an access database and tell you EVERYWHERE you used a field or table?

For example, I want to unlink a Table SSTAR_Orders.  I want something to tell me every form, query, report, module, VB code etc that used it so that I can redirect it somewhere else.  Others I don't want to redirect, but just remove, so just need to go clean them up.

Is this possible??
0
sharpapproach
Asked:
sharpapproach
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
sharpapproachAuthor Commented:
VERY COOL DATABASEMX!  This worked briliiantly.....THANK YOU!!!!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are welcome.  You now have a 'sharp approach' to solving these problems :-)

mx
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now