JOhn said:
Has anyone seen this error bfore -1517? There is nothing
on the webage about this error. We are using Access
2000.We get the error when we try and update a form.
Unfortunately searching for an error number with a - in front doesn't
work well as most search engines see the - and explicitly ignore all
pages with the 1517 on it.
I've noticed this problem several times when I've added a foreign key
to a table in the backend which was inserted into the middle of a
table. Everything would work fine for days or weeks until the backend
was compacted. Then the FE would puke with the -1517 error you
mentioned whenever that particular table was accessed. But deleting
the link and recreating the link made it work again.
http://www.granite.ab.ca/access/reservederror1517.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