Results 1 to 3 of 3
  1. #1
    SAugsburger is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2014
    Posts
    6

    Attempting to find every form where a specific table field is unlocked

    I have a modest sized MDB ~100MB and I have a field in a linked table that appears to have changed somehow, but I am not aware of any place in my Access DB where the field would be editable. What would be the easiest way to find all references to a specific table field in every form in DB so I could figure out from where the field was unlocked?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    Access does not have an intrinsic utility for that kind of search. Need third party app. I use Rick Fisher's Find and Replace. Costs about $50. Saved my sanity more than once. Don't know if it is compatible with Access 2013.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    You might try Ribbon - Database Tools - Object Dependencies. Clicking on a Form will give you the Fields for that Form.

    What, exactly, does "I have a field in a linked table that appears to have changed somehow" mean?

    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-03-2014, 08:27 PM
  2. Replies: 14
    Last Post: 04-25-2013, 05:14 PM
  3. Replies: 22
    Last Post: 04-25-2012, 10:03 AM
  4. Replies: 5
    Last Post: 03-03-2011, 03:56 PM
  5. Find specific value in any field
    By bkvisler in forum Queries
    Replies: 8
    Last Post: 12-08-2010, 04:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums