I have some vba code that I use to refresh the links to the back-end tables in a split database. The back-end tables are on a server. the code cycles through each table with error checking/trap for each table. If I use the linked tables manager and do the process manually, there is no error. However, once I run the code at start-up, I get error 3011 "The Microsoft Access database engine could not find the object ....if [ObjectName] is not a local object, check your network connection or contact the server administrator"
The missing object name seems to be a test form from very long ago (can't remember), which I have long since deleted. I tried auto name correction, compact and repair but the error persists. Is there a way to search the entire database to see which tables or query might be calling this object? Alternatively, is there a way for the VBA code to disregard this object and continue with the table linking? Is this a network/permission issue?