query couldn’t be run or database table couldn’t be opened check the database table could not be opened (MS access +Excel)


full error query couldn’t be run or database table couldn’t be opened check the database. check your database server or contact your database administrator, make sure your database is available and hasn’t be moved or re-organised

Error comes up when user tries to refresh data data from Ms Access from an excel spreadsheet.

The both are on shared drives and user has access to both on shared drives, and can open the Ms access table directly from MS access.

Ran out of ideas