Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MsysCompactError, Paste Error, Relationships missing

Posted on 2006-07-18
9
Medium Priority
?
1,078 Views
Last Modified: 2012-06-21
Is it possible for a Repair and Compact to actually remove all the relationships in a database, as well as the primary key in the main table due to a MsysCompactError, and then a Paste Error?  I am trying to determine what happened, as I think someone might have been fooling around with the DB, but I want to make sure what this is before I point any fingers.  

We do almost daily repair and compacts, and I take random backups (in addition to the network backups every night).  I went to make a change in the DB and noticed that all the relationships were missing, and the primary key in the main table had been removed.  Around that time a rather inept SQL programmer had been asked by management to look into importing the back end into SQL, so I intially assumed that he had messed up the table and then reimported it without knowing what he was doing.  Now though, I have discovered the MsysCompactError table and Paste Error table in one of my backups, and this is the first one where the relationships disappeared.  Database is working fine, and those two tables seemed to magically disappear on their own - would the next successful repair and compact get rid of them?  

Sooooo...is it possible for all this to occur just because of an error during repair and compact??????  And is it possible for the tables to disappear on their own?  Or has someone been monkeying with my DB :(
0
Comment
Question by:bcad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 2000 total points
ID: 17130923
If compacting over the network this is very possible.  I suggest that you copy the database locally to your workstation or do it from a remote desktop on the server.  And use the jetcomp utility instead of the Access compact.

http://support.microsoft.com/kb/295334/en-us
0
 
LVL 1

Author Comment

by:bcad
ID: 17131108
I have never before seen a Paste Error table delete itself though, so this is what made me suspect that it had some help.  Is it possible for Access to delete the Paste Error and MsysCompactError tables all by itself??

0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17131383
The MsysCompactError is created at compaction by access.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 1

Author Comment

by:bcad
ID: 17132042
Yes, I understand that, but is that a table that would be deleted automatically the next time you successfully repaired and compacted?
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17132102
Exactly.  It looks like you have a bad compact/repair.  Yo probably need to go back and restart from the last known good database.
0
 
LVL 1

Author Comment

by:bcad
ID: 17140255
And this bad compact/repair could delete primary keys and relationships in the DB???  I have never seen this happen before...
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17140358
If you have a DB that is looking for the MsysCompactError that means it wasn't a good, complete compact and repair.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question