Topics Search

MSysCompactError - How to troubleshoot?

MSysCompactError - How to troubleshoot?
Views: 49
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:

More 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

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 datasheets and subdatasheets

When two tables have one or more fields in common, you can embed the datasheet from one table in another. An embedded datasheet, which is called a subdatasheet, is useful when you want to view and edit related or joined data in a table or query.

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 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.