Hello,
I'm occasionally getting error 3078 "database engine could not find the object 'TableName'", while the ODBC linked tables exist, and can be opened from database pane.
Back-End is SQL Server 2012, front-end is Access 2010.
the error happens on lines sort of:
With CurrentDb.OpenRecordset("select ..", dbOpenDynaset, dbSeeChanges)
and
Dlookup(..)
What could be the fix here?..
Thank you