Microsoft Access Database Not Pulling Up to Date Data from SQL

Question

Hello:

Long story short, someone designed a Microsoft Access database that I have been tasked with running reports from.  He is not returning my phone calls.

Anyway, this database is only pulling data up to October of 2014.  We should be seeing data at least up through September 2015.

This Access database connects to our main database in SQL through an ODBC connection. 

And, there is of course data in the SQL database that extends into 2015 and beyond. 

What are some common reasons as to why an Access database would not pull "up to date" data from a SQL database through an ODBC connection?

Thanks!

John

Answer 1

We don't know what you know or do not know about Access. Can you run the report, then click the button in the Ribbon to put it in design view, then inspect the RecordSource property, and other properties such as Filter (all on the Properties window).

If the RecordSource is a query, open that query in design view and inspect it. There may be something on the Criteria line that restricts it to old data.

If none of this yields results, inspect the code in the Button_Click event which I'm assuming you run the report from. DoCmd.OpenReport has an optional argument to provide a Where-clause which can restrict what data you are seeing.

If all of the above is TOTAL GREEK (or GEEK) to you, hire some professional help. Should not take too long to figure out.

Answer 2

What are some common reasons as to why an Access database would not pull "up to date" data from a SQL database through an ODBC connection?

Thanks!

John

There is no reason for not pulling up data from a linked table. However, there are a few possibilities if you are not looking at the data directly. You say you are pulling up reports. How are you doing that? The most likely possibilities is that either the report and/or the query its based on are filtered in some way.

Answer 3

If you look directly in the linked SQL tables do you see all the data? Perhaps the Reports are date filtered, or are based on queries which only return 2014 data. Without knowing more about the nature of the problem it's hard to give specific advice!