Reserved error -1517 in fields

[Guest]

Hello!

Yesterday I coded compact and repair to my database. I have a split database
with 5 tables in the back end. Now when I run the code and the compact and
repair in it and right after that open any one of the linked tables from the
front end, I have fields in the table that say "#Error". If I check out the
same table in the back end, it looks normal.

If I don't run the compact and repair code the error doesn't occur.
If I close the front end after running the code with the compact and repair
of the back end and open the front end again, the tables don't have errors
anywhere.

What is going on? The error is "Reserved error (-1517): there is no message
for this error".

I do the compact and repair like this:
DBEngine.CompactDatabase "path to backend", "same folder: temp.mdb"
Kill "backend"
Name "temp" As "backend"

- Beginner -

 

[Tony Toews [MVP]]

I found this text from the web:
"The error is because a column ID is not valid in a linked table."

The above is not quite accurate. It is more that you've inserted a
field in the middle of a table, you've compacted the back end, and now
the cached data in the linked table doesn't match the field data in
the back end.

Hmm, you likely got that from my website. It's a direct quote from
Michael Kaplan though.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/