ODBC Microsoft Access Driver Login Failed

[Mark44stfc]

Hello All,

I have an excel workbook which is linked to an Access Query via the Data>Get Data

Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me.

The past couple of days I have started to receive the following:

"ODBC Microsoft Access Driver Login Failed

Your network access was interrupted. To continue, close the database and then open it again"

The database isn't open so I'm a tad confused. Any ideas what may be causing the issue?

 

[james_lankford]

can you close excel
then open the access database and do a "compact and repair'
then close access
then open excel and try again