Results 1 to 6 of 6
  1. #1
    viviangrayjr is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    3

    Error 3011 when linking tables with vba code

    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?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    A deleted form should not have any effect on relinking tables.
    You may have some corrupted code. Try decompiling to remove corrupted code.
    Also try copying all objects into a new blank database.
    'Phantom' objects will be left behind

    If still an issue, do a search in the VBE for this item.
    Also check the hidden, system table MSysObjects and see if the object exists.
    You could also download the free VTools addin which has a deep search and replace tool.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    viviangrayjr is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    3
    Thanks. I will try this.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    In case you don't know about decompiling - see http://www.fmsinc.com/microsoftacces.../decompile.asp
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    viviangrayjr is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    3
    Hey Colin. I wanted to let you know that I checked I found the "missing" object in MSysObjects as you suggested. Now to the difficult part: since this is read only, how do I get rid of this "ghost"? Thanks.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    See this article on my website http://www.mendipdatasystems.co.uk/r...cts/4594424204
    This describes how to fix 3 different types of error in MSysObjects.
    Let me know how you get on.
    If none of those work, the other solution is to import all objects to a new blank database but I'd only do that as a last resort.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-27-2018, 01:11 PM
  2. Replies: 10
    Last Post: 02-18-2016, 09:44 PM
  3. Access 2013 Error 3011 cannot find object
    By etorasso in forum Access
    Replies: 2
    Last Post: 10-05-2015, 09:51 AM
  4. Replies: 3
    Last Post: 07-29-2014, 01:01 PM
  5. Replies: 6
    Last Post: 12-21-2012, 02:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums