MS Access Error 3078

ForresterCA
ForresterCA used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Rey Obrero (Capricorn1)
Top Expert 2016

Commented:
always refresh your linked table connections when opening your db.
ForresterCA

Author

Commented:
mean TableDefs.Refresh ?
Commented:
if anyone is still interested..

I should have informed that the application has shared front-end.
on start it executed re-linking of attached tables.
thus, if any user was already online, then new user when executing re-linking (delete+attach table), was temporarily killing tables.

the solution is to eliminate re-linking on start.
now we re-link only once, when publishing application.
and, I know, I know, we should never use shared front-end :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial