Error -3100. Please Help!

[Robert]

I know very little about Access. What I do know was self taught, so forgive
my ignorance.
I was getting an error, which I saved as a table, everytime I opened my db.
The table has the following:
in the "error code" field is "-3100"
in the "errordescription" field is "unknown"
in the "errorrecid" field is ""
in the "errortable" field is "MSysRelationships"

What have I done wrong? The db is nothing more than a means to keep track
of my dental continuing education hours for my state board. As long as this
table is saved as MSysCompactError, the error no longer appears upon opening
the db.

???????????????????????????????????????????????????????????
PS: Any programmers want to get with me on this to compile something
useful? It could be marketed to state dental and medical associations for
professionals who want to keep track of the CE hours that their state boards
require.
???????????????????????????????????????????????????????????

 

[NetworkTrade]

don't know answer. I would

1. google the exact error message within " " so you get responses
concerning exactly that same error message and see what others report.

2. as you seem to imply this to be a rather simple db - try whipping up
just a quick and dirty duplicate - and see if it has same problem...not sure
what it will tell you - but is a good sanity check if do-able....

 

[Robert]

Google and Microsoft came up ziltch for -3100. I'll keep looking however.
Many Thanks.

 

[Robert]

The problem with the error popping up each time I opened the db went away as
this table was created by "Compact & Repair."
I was just trying to figure out what the error was that Compact & Repair
"fixed" so I could go back in the db and remove it for good. If I delete
the MSysCompactError table, the error starts popping up again each time I
open the db. Thanks for the input though.

 

[Tony Toews]

I know very little about Access. What I do know was self taught, so forgive
my ignorance.
I was getting an error, which I saved as a table, everytime I opened my db.
The table has the following:
in the "error code" field is "-3100"
in the "errordescription" field is "unknown"
in the "errorrecid" field is ""
in the "errortable" field is "MSysRelationships"

What have I done wrong? The db is nothing more than a means to keep track
of my dental continuing education hours for my state board. As long as this
table is saved as MSysCompactError, the error no longer appears upon opening
the db.

Try importing your objects into a new MDB.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm