Repost - MSysCompactError

[JohnB]

Hi. I posted the message below yesterday, with no
response. Can no one help with this? Ive tried deleting
the MSysCompactError table and then recompacting and
repairing the db and I get the same table appearing but
with nothing in the ErrorRecid field. Ive even tried
adding a field called Description to the Placements table
but when I run a Compact and Repair again, it still says
it cant find that field. Any ideas anyone? Thanks.

My db is Access 2002 on XP, networked.

Ive had two occurrances of a problem recently and I
posted about this in General Questions on 18th Feb with
no
replies (Invalid Argument Problem). Ive now discovered
that a Compact and Repair fixes the problem, at least
temporarily, without my having to delete and reinstate
any
records. Can anyone help me interpret the contents of a
table that is being generated, called MSysCompactError?

The table contains one record, consisting of four fields -

ErrorCode, ErrorDescription, ErrorRecid and ErrorTable.
The field contents are as follows

ErrorCode, -1003
ErrorDescription, Could not find field Description (the
word Description is in quotes but when I use the quote
symbol in this Newsgroup it comes out as a series of
numbers).
ErrorRecid, this field contains one Chinese and one
music
notation character.
ErrorTable, Placements

I have looked in my Placements table and there is no
field
called Description. Why does Access think there should be?

What does error code -1003 mean? I tried looking in
Access
Help but cannot find a listing of error codes.

Finally, if there is some sort of corruption in the
Placements table, is there a way to fix it once and for
all, or is this just a transient network problem? I am
unsure of the cause of the problem - I havent managed to
reproduce it myself.

Thanks for any help. Cheers, JohnB

 

[Arvin Meyer]

There is no error number 1003 that I can find. It seems that you have a
corrupt row of data. After compacting, import the tables into a new
database. That "should" leave the corrupted record behind.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[JohnB]

Thanks for replying Arvin.

Do you mean I should open a brand new db, then copy all
of the tables, forms, queries etc into it? That would be
quite a job - although Ill do it if I have to. I wondered
if something else might also work.

I was thinking of creating a new table with exactly the
same fields as the corrupt one, then use an append query
to copy all of the records across. Then temporarily
remove the table links and swop the two table names over.
Is that likely to leave the corruption behind too?

Again, thanks for the help. Cheers, JohnB

 

[Roger Carlson]

Actually, it's not all that difficult. Go to File> Get External Data>
Import. Select the database you want to import from. Then just click every
tab in the dialog box and click the Select All button. Be sure to click the
Options button on the Tables tab so you can import menus and import specs as
well. Once that's done, just click OK. That's it.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[JohnB]

Thanks Roger. Ill give that a go. Cheers, JohnB

-----Original Message-----
Actually, it's not all that difficult. Go to File> Get External Data>
Import. Select the database you want to import from. Then just click every
tab in the dialog box and click the Select All button. Be sure to click the
Options button on the Tables tab so you can import menus and import specs as
well. Once that's done, just click OK. That's it.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe? SUBED1=ACCESS-L




.