How to find out where table is used?

idiotidiot Member Posts: 651
In this heavily customized database with multiple companies, there are two custom tables, one is version1 (older), the other version2 (new).

All references should be made to version2 table, but I was told that there are still functions somewhere referring to version1 table. I need to ensure all are getting data from version2 table.

How to find out these references that are still pointing to version1?
If deny read takes precedence then all is simple... ](*,)
NAV - Norton Anti Virus

ERP Consultant (not just Navision) & Navision challenger

Answers

  • ara3nara3n Member Posts: 9,256
    Load the objects into developer toolkit and do where used.

    You can also create a new db. load the objects and delete the table and compile the rest. Any of the objects that don't compile take a look.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • garakgarak Member Posts: 3,263
    if you doesn't have the devtool you can transfer all objects to a new, empty database. than you delete your "old" table and then strat thje compiler in object designer. ow you will see all objects with errors. Some objects with errors are standars objects where a ocx or automation is missing, but you can set a filter to your customized objects.

    Regards
    Do you make it right, it works too!
  • idiotidiot Member Posts: 651
    Thanks for all your help
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
Sign In or Register to comment.