Results 1 to 3 of 3
  1. #1
    Alpharavenz is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2015
    Posts
    2

    How can I copy a list of saved query names from MS access 2010?


    I need to go through a large list of saved queries and decide which ones can be deleted and which ones are still being used by staff. I'd like to copy all the query names out of access and paste them into an excel spread sheet so I can sit down with members of staff and mark queries that can be disposed of. So far I've been unable to find a way to create a list as described above. I am working with a couple hundred queries so I'd prefer not to have to do this task manually. Thanks for any help you can give.

  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,770
    You can find objects listed in a system table, which is hidden by default. So change db setting to reveal hidden tables. Right click on "All Access Objects" at top of Navigation pane > Navigation Options > Display Options at bottom of dialog.

    Filter the MSysObjects table for Type 5. Can also build a query. Export or print.
    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
    Alpharavenz is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2015
    Posts
    2
    Thanks, worked perfectly!

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

Similar Threads

  1. Replies: 6
    Last Post: 02-28-2015, 01:23 PM
  2. Replies: 1
    Last Post: 04-21-2014, 08:00 AM
  3. Search saved names
    By Skroof in forum Access
    Replies: 3
    Last Post: 05-07-2012, 04:16 PM
  4. Access 2010 Saved Imports
    By Tomfernandez1 in forum Access
    Replies: 1
    Last Post: 09-27-2011, 12:27 PM
  5. Replies: 1
    Last Post: 05-17-2010, 12:21 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