Results 1 to 5 of 5
  1. #1
    trb5016 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Pennsylvania
    Posts
    71

    "ID is not an index in this table" Error (I know it's corruption?)

    So I have a split database. Front end is a .mdb file and backend is on a MySQL server.



    Each user has a copy of the database saved locally. I have a local developer version that updates a "master" version stored on the network. The users' database then can update itself from that master version when need be.

    However, the local copy on the users machine (not mine) has been getting (apparently) corrupted very quickly resulting in the given error.

    All the articles I've seen say make a backup and to split your database and to ensure everyone is running a local copy. There is no data loss and the Master and developer versions of the DB remain uncorrupted.

    I'm at a total loss as what to do. The user can edit data just fine until this corruption occurs and then needs to delete the local database and restore it with a copy of the master.

    Any ideas? Even crazy ones...?

    Thanks

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    is the corrupted FE also an unusually large file size?....it generally is.

    Fundamentally there is a design problem that the users are triggering - and the task is to figure out what that is.

    One place that I look is the creation of temp tables - - this can bloat the FE until it maxes out in size and crashes....and is easily fixed by either changing the design or implementing the 'compact on close' feature - although some do not recommend that approach.

    SQL BE is a bit of a wild card and not sure if that is a factor - but otherwise can you have the users point to what they were doing when it last bombed ; perhaps that will point to the cause.

  3. #3
    trb5016 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Pennsylvania
    Posts
    71
    The database is hovering around 6,600 KB when compacted.

    It's gotten up to 11,000 KB that I've seen. I try to compact it before sending it out.

    (Compact and Repair is on for the user too... is that bad?)

    I don't have any temp tables being created. There are maybe 6 local tables to store DB properties and then about 50 linked to MySQL.

    I did change the location that the user had her local copy and the problem hasn't occurred again (yet, crosses fingers)

    Thanks for your ideas - all thoughts are appreciated

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    well its doesn't sound like it is crashing due to size bloat max.

    it is doubtful that a move of the FE to a different location would change anything - - - so it will probably re-occur (though one never knows)

    that specific error message is not familiar to me; you should google it and try and find other Q&A on that error for Access.

    when an app is crashing - the error message it flashes is not often helpful - - but maybe you are really not crashing but instead 'throwing an error' that is due to one specific cause and so that message will be the key. So besides better understanding the message - when an app 'throws an error' it is a very specific pinpoint situation - - - so question the user as to exactly their sequence of events and see if you can cause that same error on your development copy.....

  5. #5
    trb5016 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Pennsylvania
    Posts
    71
    From what I've google'd out of this message it seems to occur randomly with corruption.

    The causing sequence (as best I can tell) is the user uses the database fine. Closes it. Opens, uses, closes. Then when they attempt to close it the error message comes up multiple times before access is allowed to close.

    It then occurs on database open again. Very strange.

    I guess I'm going to hold my breath and hope it miraculously fixed itself.

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

Similar Threads

  1. Replies: 13
    Last Post: 12-05-2011, 05:10 AM
  2. Replies: 0
    Last Post: 03-04-2010, 06:32 PM
  3. HyperLink error "No Program registered ..."
    By RycherX in forum Access
    Replies: 1
    Last Post: 02-09-2010, 03:36 PM
  4. Error message and How do I find the "value Field" ?
    By createdwithfire in forum Forms
    Replies: 1
    Last Post: 11-05-2009, 12:26 PM
  5. Replies: 21
    Last Post: 06-03-2009, 05:54 PM

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