Results 1 to 2 of 2
  1. #1
    moody6086 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2019
    Posts
    1

    Databases/Queries associated with Saved Imports/Exports

    I've searched on this forum and have been unable to locate an answer to my question, so I've decided to post it here.



    I inherited a support role for an Access DB, which contains a significant number of Imports/Exports. I need to figure out the tables/queries that are associated with these imports/exports. I’ve researched and have been unable to find an answer.


    The closest answer I’ve gotten is to use the MsysIMEXSpecs table; however in my database I see over 100 imports and exports, but only 30 records in this table. Plus this table doesn’t appear to have much information in it. I feel like this should be an easy thing, but I just can’t figure it out.

    Can anyone offer an answer as to how you can find out what queries/tables are utilized within saved imports/exports?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    1. Look at all your modules, the code in them will tell you which imports/exports are being used
    2. Look at the code associated with any forms where a button click may be performing an action to import data. Those buttons may have a macro or some vba code attached to them running queries in a sequence
    3. Rename the queries one at a time and see where/if you get error messages in your import process

    the last one isn't a great option as it's kind of hit or miss

    If you go the route of searching code, just do a systematic search for each query name in your query toolbox

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

Similar Threads

  1. Saved imports and exports disappeared from manage data tasks view
    By mmoria2312 in forum Import/Export Data
    Replies: 8
    Last Post: 11-07-2016, 05:07 PM
  2. Replies: 2
    Last Post: 02-07-2015, 11:20 PM
  3. pass paramaters to query in saved imports
    By nirvana in forum Import/Export Data
    Replies: 9
    Last Post: 03-15-2013, 07:58 AM
  4. Changing File Location in saved imports using VBA
    By akshatagarwal93 in forum Import/Export Data
    Replies: 3
    Last Post: 07-23-2012, 10:47 AM
  5. Access 2010 Saved Imports
    By Tomfernandez1 in forum Access
    Replies: 1
    Last Post: 09-27-2011, 12:27 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