How to find out where table is used?
idiot
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... ](*,)
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
ERP Consultant (not just Navision) & Navision challenger
0
Answers
-
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.0 -
-
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.
RegardsDo you make it right, it works too!0 -
Thanks for all your helpNAV - Norton Anti Virus
ERP Consultant (not just Navision) & Navision challenger0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
