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


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.


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?


Switchboard OptionLabel7 problems
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
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.


Access Error
I have a program that I have written that has worked fine up until I started cleaning up some of the mess (useless code and forms). Now I have one form that when I click on the open button, it generates the message "Microsoft Office Access has encountered a problem and needs to close." Is there an easy way to troubleshoot this problem? I have tried to compile the program and get the same error. I think the problem actually started when I tried to make an ACCDE file. I even have an old copy of the program before I made any changes, and it still gets the same error message


Export data to a text file
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


Can we run Access 2003 db from Access 2007?
This is likely a bonehead question, but it would be good to find out.

I just inherited a couple of databases that are in Access 2003. They are used for data entry/reporting by about a dozen people, however I will be the only one doing any administration on them. I do not want to convert them to 2007 yet, as I'm not familiar enough with them to troubleshoot issues.

Currently, everyone has Access 2003 & 2007 installed on their PCs so they can access this DB. Is there any reason we can't have everyone access the database using Access 2007? If I did any changes to the database structure, I would use Access 2003, but I've been looking at is using Access 2007, and don't see why people can't run it using


"User-Friendliness"
Looking for some design thoughts on keeping my DB applications "user-friendly." Like most of you I have a certain "signature" or method as to how I like to see my databases setup/designed.

For example: I tend to incorporate menu bars & tool bars into my apps instead of using a menu/switchboard. However, I find that many basic users would rather see a menu/switchboard.

I already use features such as runtime and FE updating. I also use an Error log table to help troubleshoot when a user has a difficult time telling me what is going on.

In my development experience, I have found that not only are many end-users not Access Savy, they are generally not all that PC savy.

So, what are some things that you do to keep your designs as user-friendly as possible?


Best way to share a split DB?
I designed a database for a company at their local branch and now I live far away from the office so I can't access the DB directly on the company systems. The company will call me from time to time to troubleshoot or change things around.

In my opinion the best way to around that was to have the guys share the backend with me on a Google Drive, and I could make whatever changes they want.

If they want frontend changes, I'd just send them a modified copy of the frontend. I am not allowed access to their network because of IT regulations at the company.

I also found it really hard to work with backend and frontend copies because once they would share the BE and FE. The FE could no longer find the BE and I'd have to create a new database and import the forms and queries from the FE and then the tables from the BE.

EVERY TIME. This is starting to ruin the fun of having a split DB in the first place.


Spelling or grammar checker flags text I don't want or expect it to flag
Sometimes you may want the spelling and grammar checker in your Microsoft Office program to ignore mistakes in some text. In other situations, you may not understand why the grammar or spelling checker is flagging some text, where the text may consist of a single word or an entire document.
What do you want to do? * Add a word or phrase to your custom dictionary * Ignore text or an entire style * Hide spelling and grammar errors in a Word document * Troubleshoot grammar checking in Word and Outlook * Ignore original message text in Outlook * Always ignore data in a field in an Access table
* Turn off fields for the spelling checker in Project * Resolve other issues.