A query has landed on my desk - which i'm struggling to figure out.

I have an Excel 2007 workbook which pulls data from a shared Access database.

The user has complained that it is not working properly.

To test it I attempted to refresh the connections, and get an error message:

ODBC Microsoft Access Driver Login Failed

Which then continues to say that it cannot find the mdb file. However, the path that it states the file should be in is different to where it is. This was working fine yesterday.

We also had a mandatory service update overnight - would this potentially cause this?

I'm trying to figure out if the file has been moved, whether it is a problem with the ODBC setup (and therefore infrastructure can have a look), or whether I have inadvertently changed something within the database itself (although I have only been creating queries).

Any help would be much appreciated!