Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unhappy Unanswered: Compacting and Conflict Errors

    We are having a problem with our Access2000 Database when we compact, the MSysCompactError table is deleted, andwe then cannot replicate becasue it says it can not find this table. The administrator copied the table and pasted it into the database from the backup. It will then allow you to replicate but it will not sync, it has an error saying it can not find the Switchboard Items which we do not have and havn't had in our database at least not to anyone's knowledge (the creator of this monster has long since left this company). As long as we do not compact we can replicate and synchronize, but this isn't really a fix to the problem.
    One of the other issues going on with this database is sometimes it will not synchronize and come up with an error that there were conflicts, and then ask if you want to fix them when you click yes (or OK whichever one it is) it doesn't come up with anything, it just, makes the error window go away. When we go to the conflict tables there are items listed there, but they do not show any conflict.
    Anyone have any ideas? Short of dumping the whole thing and starting from scratch(which we have all suggested but the people with the $$$ say no way) We are at a loss here so please HELP!

  2. #2
    Join Date
    Jan 2003
    Location
    Wisconsin
    Posts
    8

    Re: Compacting and Conflict Errors

    Have you tried starting a new blank mdb, pulling in all your objects from the old, and then messed with the replication stuff?

    I read somewhere that this may help in some corruption cases.


    Originally posted by ljlasala
    We are having a problem with our Access2000 Database when we compact, the MSysCompactError table is deleted, andwe then cannot replicate becasue it says it can not find this table. The administrator copied the table and pasted it into the database from the backup. It will then allow you to replicate but it will not sync, it has an error saying it can not find the Switchboard Items which we do not have and havn't had in our database at least not to anyone's knowledge (the creator of this monster has long since left this company). As long as we do not compact we can replicate and synchronize, but this isn't really a fix to the problem.
    One of the other issues going on with this database is sometimes it will not synchronize and come up with an error that there were conflicts, and then ask if you want to fix them when you click yes (or OK whichever one it is) it doesn't come up with anything, it just, makes the error window go away. When we go to the conflict tables there are items listed there, but they do not show any conflict.
    Anyone have any ideas? Short of dumping the whole thing and starting from scratch(which we have all suggested but the people with the $$$ say no way) We are at a loss here so please HELP!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •