Results 1 to 6 of 6

Two Different MS Access Databases

  1. #1
    MidwestAnalysts is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2017
    Posts
    2

    Two Different MS Access Databases

    Hello Friends

    I'm struggling to find a source / solution of a major problem I'm stuck into. Kindly advise if you have any suggestion.

    I'm assigned with a new task to map a report which is generated from a "Y" MS Access database and to identify all the input and output source. With my limited MS Access knowledge I'm trying to solve this puzzle but kind of stuck.

    Scenario: There are 2 different MS Access database (X & Y) which is connected with ODBC. Everyday someone from admin team runs a update on "X" database ( a tab which automatically fetch the latest update from ODBC and update MS Access). Once the admin is done updating the "X" Database they sent a manual mail notification to the "Y" database team that they have updated the "X" database and following to which "Y" team generate a report from "Y" database. Y team only able to generate the latest report from their database when "X" database has been updated. If "X" database has not been updated and still "Y" team try to generate the report for that specific day then they get a blank report. I have checked both "X" & "Y" databases and picked a specific day and gone thru the data to match and it has way few similar agent ID's but way different data.

    Question: My question is how these 2 MS Access database are talking to each other? I have checked the syntax and code and couldn't find any reference or connection any where. Since both the databases has different data on any randomly selected day that means the "Y" database is getting some more updates from different source including the "X" daily update. How should I find out what is happening here as colleagues have No idea what is happening. The Database designer is no Longer with the company and there is no Documentation. is there any way to find out what is the connection between these 2 database and how they are pushing and pulling updates?

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    342
    Perhaps it could be linked tables? Perhaps it could be fully referenced database path within queries that select and append records to Y, or the same within the code? You might could use a tool like MZ Tools (https://www.mztools.com/v8/download_trial.aspx) to search for the X database name within the project.

  3. #3
    MidwestAnalysts is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2017
    Posts
    2
    Thanks a ton for your prompt reply jWhite. I just checked with the System Admin and unfortunately they can't provide me the MZtools and I don't have the rights to download any external thing on my machine. You may be right, as I have seen the Daily report append qry and researched it by opening it in the design view as well as in sql view but still couldn't find the "Y" database reference anywhere.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    11,121

  5. #5
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    342
    I feel your pain... It sounds like you also would not be able to upload the database here for review. Perhaps you could post just the query code? It may come down to telling them if they want it resolved, you need the tools that will allow you to track down the answer.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    11,121
    How should I find out what is happening here as colleagues have No idea what is happening. The Database designer is no Longer with the company and there is no Documentation.
    Hopefully this isn't critical to the viability of the organization. Seems like between rock and hard place...

    Is there any way to find out what is the connection between these 2 database and how they are pushing and pulling updates?
    I just saw jwhite's response, and I agree that if you want help from the forum, you're going to have to give some info/clues/jpgs etc so we can try to understand the reality and try to provide some "best guesses" to find answers.

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

Similar Threads

  1. WSDL with Access Databases
    By Perceptus in forum Code Repository
    Replies: 0
    Last Post: 02-19-2015, 12:36 PM
  2. Two MS access databases synchronization…
    By Aemosha in forum Database Design
    Replies: 3
    Last Post: 01-22-2015, 01:49 PM
  3. Replies: 3
    Last Post: 10-24-2014, 09:38 AM
  4. Need help linking access databases
    By AlphaNumeric in forum Access
    Replies: 2
    Last Post: 05-18-2010, 03:08 PM
  5. Converting Access Databases
    By awpic1964 in forum Import/Export Data
    Replies: 1
    Last Post: 08-04-2008, 05:54 AM

Tags for this Thread

Posting Permissions

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