MSysCompactError - How to troubleshoot?

I'm running Access 2007. Today I split my db into frontend and backend. When the split was done, I get a table called MSysCompactError.

ErrorCode: -1002
ErrorDescription: MSysCompactError ErrorDescription '|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
ErrorTable: MSysRelationships

I also noticed that I cannot open one of my queries in design view anymore, I'm not sure if it's related but I suspect it is. [EDIT]: I've confirmed that it is related. I opened a backup I have before I split the DB and I could open the query in design view.

The error message I get is:

" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

How do I go about troubleshooting and fixing this problem

Sponsored Links:

Related Topics

Troubleshoot Conditional Formatting
Troubleshoot Conditional Formatting of Access 07 Report using VBA
lkpStatus.BackColor = lngGreen
lkpStatus.ForeColor = lngBlack


Why am I getting a message that says to troubleshoot my Internet connection?
When you click a category under Microsoft Office Online, you might see a message with two hyperlinks: one to try again and the other to troubleshoot your Internet connection.


db compacting
I've been using Access for several years now and as a good practice I compact the db ever so ofter. Yesterday I pack a large DB, for me, several thousand records and for whatever reason Access ate my DB - several tables are missing, but I did get a new table Msyscompacterror with a lot of error 1206 and 1907 along with a mixture of Chinese and Korean symbols.

How can I get my original DB back - I have never had this problem before


Troubleshoot PivotTable or PivotChart view
Learn how to troubleshoot PivotTable or PivotChart view.


How to troubleshoot query?
I am doing a simple query of a table of student's particulars. I'm just doing a very simple query of <First Name> and <Last Name>.

However, many of the records are not showing up. E.g. there are 159 records in the student table, but in the query, only 34 records are showing up. I have not set any kind of criteria or filtering in my query.

How do I troubleshoot this so I know why they're not showing up?


Import or link to data in a text file
You can bring data from a text file into Microsoft Office Access 2007 in two ways. If you want a copy of the data that you can edit within Access, import the file into a new or existing table by using the Import Text Wizard. If you simply want to view the latest source data within Access for richer querying and reporting, create a link to the text file in your database by using the Link Text Wizard.
This article explains how to import and link to a text file by using these wizards.
In this article
* About text files and supported formats
* Import data from a text file
* Troubleshoot missing or incorrect values in an imported table
* Link to a text file
* Troubleshoot #Num! and incorrect values in a linked table


Import or link to data in an Excel workbook
You can bring the data from a Microsoft Office Excel 2007 workbook into Microsoft Office Access 2007 in many ways. You can copy data from an open worksheet and paste it into an Access datasheet, import a worksheet into a new or existing table, or link to a worksheet from an Access database.
This topic explains in detail how to import or link to Excel data from Access.
What do you want to do?
* Understand importing data from Excel
* Import data from Excel
* Troubleshoot missing or incorrect values
* Link to data in Excel
* Troubleshoot #Num! and other incorrect values in a linked table


Epression Builder
I am trying to use the expression builder on a text box to do some calculations. Every time I press the . button Access states there was a problem and restarts. It only happens on this field. I am not sure how to troubleshoot this


Troubleshoot sorting
This topic explains how to troubleshoot sorting in Access. Problems: I cannot apply a sort order: The sort buttons are disabled, The field or column on which I want to sort is not visible, The OrderbyOn property is missing in the property sheet, Cannot find the DefaultSort property in the property sheet, I can't find the language I want in the New database sort order box. OR I applied a sort order, but: Some records are not getting sorted properly, Records are not displayed in the right order, Sorting seems to slow down the database, I get the message "The DefaultSort property is invalid.", Numbers are sorted based on the first character instead of on their numeric values, I created a report based on a query, but the query sort order is not reflected in the report, Sort order is not being saved, Sort order is not being applied, I don't want Access to apply the sort order automatically, The sort order is lost during an export operation, Access isn't using the sort order I specified in a linked table, I receive replication errors after I change the language sort order.


Troubleshoot problems when pasting data
Problems: Microsoft Access can't paste the data, The data I pasted is in the wrong field.


Troubleshoot installing an Office program
I installed a shared Office program, but the program can't be found.


Troubleshoot editing data in a field in Datasheet or Form view
Problems: Nothing happens when I try to edit data. After I've added or edited data, I receive a message and I can't move to another field or record.


Troubleshoot hyperlinks
Problems with hyperlinks can be caused by one or more of the following occurrences:
The destination may have been moved or may not exist any more. The text you believe is a hyperlink only looks like a hyperlink. You may not have access to the destination. The destination may have been entered incorrectly.


Duplication of Records
I just inherited a database, an .mdb file. We are using Access 2007 but it had not been converted. I now notice that when a record is created in one of the forms, the record is duplicated, so it shows up twice in the form (the form was created in datasheet format in Access 2003). I will convert the database, but do want to attempt to troubleshoot first.


Troubleshoot Help
I can't access the content on Microsoft Office Online. The Search Results task pane doesn't show the help I want. The Office Assistant is distracting. The Office Assistant is not displaying programming Help topics. The Office Assistant balloon disappeared. The Office Assistant prevents me from working.


Troubleshoot HTML formatted files
Problems: My server-generated HTML files do not appear as expected when I display them in a Web browser. I can't open a file on the Internet. I want to open an HTML file in Access, but it opens in another Office program. I get an error message when I try to import or link to data on a FTP or HTTP Server.


Troubleshoot saving files
When I save a file, it is saved with an additional file name extension. When I try to save changes to a file, I get a message saying the file is read-only. The file I saved contains two periods in the file name. I entered my username and password but I still can't access a network drive. When I save a file, I get a message saying there is insufficient disk space or memory.


Troubleshoot Append Query Errors
I am creating new tables using a select query and then an append query. The select query to is to eliminate duplicate records before appending. However when I run the append query I get a dialog box indicating that 9 of records cannot be appended due to errors.

Is there any way to get access to tell me which records these 9 are? I know I can figure it out, but it would be nice to see what records or what step of the process creates the error.


can not find 2427 you entered an expression that has no value
I have a report that prints from a qry and I get the error "2427 You entered an expression that has no value" . I get the error twice. The form will print once I acknowledge the two errors but I am attempting to eliminate the error messages and I can not find anything that is causing the errors. Any ideas on how to troubleshoot or track down these errors?


ADODB.Recordset error '800a0cc1'
I am getting the following error message:

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

/costshare/fpdblib.inc, line 7

Here is line 7 of fpdblib:
If Not IsEmpty(rs) And Not (rs Is Nothing) and Not IsNull(rs(fldname)) Then

I used Frontpage to create this, it has been working fine. How should I troubleshoot this?