Only partial data obtained from connection with Access 2007

[mccloy1285]

Hi,

I have a data connection in Excel 2007 linked with an Access 2007 file. On my computer it works fine but on my colleagues computer it doesn't quite work.

When he opens and updates the file, the linked table deletes some data. In the table once it gets past 13/08/2015 it does not produce any data until 01/09/2015, there are no blank rows but just missing data during this period. This missing data means that #REF! errors are produced in cells which use these dates when I run data refreshes and macros.

When I open the sheet again and refresh the missing dates 13/08/2015-01/09/2015 are then populated and this removes the #REF! error and the sheet works fine. This isn't a critical issue but its annoying that something isn't quite going right on his computer.

Thanks I really appreciate your help.

 

[mccloy1285]

Found the problem for anyone interested, the date on my computer was set up to English UK, i.e. the 13th August was 13/08/2015, whereas on my colleagues computer they had the English US format of 08/13/2015.
This meant that the 13/08/2015 coming from the access database was not recognized as there are not 13 months in a year. Took me a long time to figure this out so hope it helps someone and saves them a lot of time!