Reserved error(-1517)

[Steven Callahan]

This error appears while a form is open in one of our
databases. Could some one explain what this error is and
how to fix what ever is causing it.

The message box reads Reserved error (-1517) No message
for this error.

I don't have a lot of time to spend on this for the next
couple of weeks and I need to fix the problem right away.

Thanks,
Steven

 

[Tony Toews]

This error appears while a form is open in one of our
databases. Could some one explain what this error is and
how to fix what ever is causing it.

The message box reads Reserved error (-1517) No message
for this error.

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

 

[Joan Wild]

This error will occur if you change the design of a table, but don't follow
through with a compact. If your database is split, it is a good idea to
compact the backend after a design change, and also refresh the links in the
frontend and compact it.

 

[Steven Callahan]

Thanks to Tony and Joan for your replies. Refreshing
Links to Linked Tables seems to have fixed the problem.

Thanks,
Steven