Results 1 to 2 of 2
  1. #1
    Sightly is offline Novice
    Windows 8 Access 2016
    Join Date
    May 2020
    Posts
    4

    Property not found when trying to open a table

    I just came in today and tried to open my access database. All of my tables I could open except for one, when trying to open it I got a “property not found” message. I think I would be able to open up a previous version but I want to know how to avoid this error in the future. I do have this table with some relationships and I have done a bit of coding using the table as a record set if either of those could have done something. Any help would be appreciated!!

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Not enough information to suggest ways of avoiding. If you are opening with code, it may be the code is trying to access a property that has not been created - properties don't exist until you create them, typically in design view.

    Or it may be the table has become corrupted - open the table in design view and check the properties. Also try compacting. Failing that, copy the data to a new table either by copy/paste or using a make table query.

    if your db is shared by users (other than the recommended method of each user has their own front end linked to a shared backend) it is possible that has caused corruption.

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

Similar Threads

  1. Item not found in this collection .Fields(x) property
    By ironfelix717 in forum Programming
    Replies: 2
    Last Post: 05-19-2019, 10:53 PM
  2. Table suddenly says "Property Not Found"
    By templeowls in forum Access
    Replies: 1
    Last Post: 05-03-2019, 08:45 AM
  3. Replies: 1
    Last Post: 01-13-2019, 01:53 PM
  4. search record if found open form.
    By cysklement in forum Access
    Replies: 3
    Last Post: 12-20-2014, 01:00 AM
  5. 'On Open' Property
    By emilylu3 in forum Forms
    Replies: 1
    Last Post: 12-08-2005, 02:28 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