Topics Search

MSysCompactError - How to troubleshoot?

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

Similar posts...

 

Why am I getting a message that says to troubleshoot my Internet connection?

Why am I getting a message that says to troubleshoot my Internet connection? Icon
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.
 

Import or link to data in a text file

Import or link to data in a text file Icon
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

Import or link to data in an Excel workbook Icon
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
 

Troubleshoot datasheets and subdatasheets

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

Duplication of Records Icon
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

Troubleshoot Append Query Errors Icon
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

can not find 2427 you entered an expression that has no value Icon
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?
 

Switchboard OptionLabel7 problems

Switchboard OptionLabel7 problems Icon
I recently inherited a database that seemed to be designed by an expert VB coder. After carefully picking through the code for about 2 days I realized the person had just used the Switchboard function.

I made a few small changes in the switchboard (through the switchboard wizard), and everything appeared to be fine. Except the Switchboard refuses to acknowledge OptionLabel7.

No matter what switchboard form, OptionLabel7 does not function. Changing what variables that are attached to that option doesn't help.

I assume the problem is somewhere in OptionLabel7 itself, since nothing in the Switchboard manager makes a difference. How can I troubleshoot this? All of the properties for OptionLabel7match the other 6 (functioning) options.
 

Merge Access data with Word

Merge Access data with Word Icon
ou can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data.
 

Export data to a text file

Export data to a text file Icon
This topic explains how to export text files by using the Export Wizard in Microsoft Office Access 2007. This topic also explains how to save the export details as a specification for future use.
What do you want to do?
* Understand exporting text files
* Export data to a text file
* Troubleshoot missing and incorrect values in a text file