• Latest
  • All
  • News
  • Business

Microsoft Access Dependencies: Why Use The Built In Object Dependency Tool And What To Look Out For

Jan 16, 2017
How to Invest in Software and Security for Your Business

Unleashing Innovation: The Power of Custom Web Application Development

Sep 9, 2023
How to install and use a proxy for Instagram with OnlineProxy?

How to install and use a proxy for Instagram with OnlineProxy?

Sep 4, 2023
Unlocking the Power of Image Resizing in the Digital Era

Unlocking the Power of Image Resizing in the Digital Era

Sep 4, 2023
Top Benefits of Learning Salesforce for Beginners

Top Benefits of Learning Salesforce for Beginners

Sep 2, 2023

The Benefits of Implementing the SBG Bond Program in Your Organization

Sep 1, 2023
How Handheld Radios Improve Communication Efficiency in Industries

How Handheld Radios Improve Communication Efficiency in Industries

Sep 1, 2023
Impact and Importance of AI in Businesses

Revolutionizing Tech: Unveiling the Power of Specialized IT Solutions

Aug 29, 2023
Salesforce Training Best Practices: Strategies for Enhanced User Adoption

Salesforce Training Best Practices: Strategies for Enhanced User Adoption

Aug 29, 2023
Worldcoin (WLD) Price Today and Market Liquidity: Understanding Trading Volume

Worldcoin (WLD) Price Today and Market Liquidity: Understanding Trading Volume

Aug 29, 2023
Worldcoin (WLD) Price and Market Capitalization: Evaluating Token Value

Worldcoin (WLD) Price and Market Capitalization: Evaluating Token Value

Aug 10, 2023
How to Make Effective Business Videos for Your Marketing Campaign

Professional Finishing Techniques for Video Restoration

Aug 4, 2023
What Is AWS (Amazon Web Services)?

Why Cloud Computing Makes Working From Home A Stronger Proposition

Aug 4, 2023
  • Guest Posts
  • Advertise
  • Contact Us
  • Privacy Policy
Saturday, September 16, 2023
Tech Featured
  • Home
  • Latest Tech
  • Apple
  • How to’s
  • Apps
  • Automobiles
  • Gadgets
  • Gaming
  • Reviews
  • Tech Tips
No Result
View All Result
No Result
View All Result
Tech Featured
No Result
View All Result
Home News

Microsoft Access Dependencies: Why Use The Built In Object Dependency Tool And What To Look Out For

by techfeatured
Jan 16, 2017
in News
0
0
SHARES
7
VIEWS
Share on FacebookShare on Twitter

An Access database is a collection of different objects stored together and in some cases related to each other to emulate logical workflows that end users simply take for granted.

How many times as a database developer or administrator have you been given an Access database and carry out an audit to understand the structure of it? There are several tools to help analyse this information but one in particular is Microsoft Access dependencies or correctly named Object Dependencies pane.

The key use that I use this tool for is to make sure that if for example I want to remove a query that I believe is now redundant and is simply taking up unwanted space, I can use the object dependencies pane view to check for a chosen object and verify where this object is being used.

The steps:

  1. In the navigation pane select the object you want to track (but you don’t need to open it).
  2. Look in the object dependencies pane (which is switched via the Database Tools tab and click the ‘Refresh’ hyperlink.
  3. Now you have one of two views to look into; ‘Objects that depend on me’ and ‘Objects that I depend on’. Switch between the two view and see the structure for the selected object.
  4. Click on another object and refresh again to view it’s structural relationship.

In order to use this tool you must first enable the AutoCorrect feature where you are prompted when clicking the Access dependencies icon.

What this utility doesn’t really cover or things to avoid are listed below:

  1. If you can view an object in design view (database is not opened in read only mode).
  2. No macro or module objects are included in this utility and therefore cannot be tracked.
  3. Other objects are of course available but certain queries are still excluded and include the Action queries, SQL specific query view and sub queries.
  4. Any Look up fields in tables and sub datasheet views are not included too.

Therefore, this tool could be approved but at least you know the level of Access dependencies and it still has value as without it you may have to keep dipping into the archive to restore a previous session.

Tags: androidimaciphonemacbooktechnology news
ShareTweetShareSendShare

For any queries, you can reach us at [email protected]

Latest Posts

  • Unleashing Innovation: The Power of Custom Web Application Development
  • How to install and use a proxy for Instagram with OnlineProxy?
  • Unlocking the Power of Image Resizing in the Digital Era
  • Top Benefits of Learning Salesforce for Beginners
  • The Benefits of Implementing the SBG Bond Program in Your Organization
Tech Featured

© 2022. All Rights Reserved.

Navigate Site

  • Guest Posts
  • Advertise
  • Contact Us
  • Privacy Policy

Follow Us

No Result
View All Result
  • Home
  • Latest Tech
  • Apple
  • How to’s
  • Apps
  • Automobiles
  • Gadgets
  • Gaming
  • Reviews
  • Tech Tips

© 2022. All Rights Reserved.