• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1828
  • Last Modified:

When running my application I get reserved error -1517 there is no message for this error

I have a front end application that links to a backend database and is used by several users. The backend started to have problems and I did a repair database, but I am still having problems. When I open the form that connects to the main table, four of the fields display the word #Error instead of the data. When I scroll through the records, I get the reserved error -1517 with no message.

I had an earlier error saying that the field named 'Description' does not exist in the table, but no form uses that field. Now I no longer get this error, but am having problems. This is an urget issue.
  • 2
1 Solution
I'm assuming this is just a standard ODBC link here ...

For now, try refreshing the link - go to the table view in your front-end, right-click on the table that's giving you trouble and go to "Linked Table Manager".  Select your linked tables and hit "OK" to refresh the link.  Then try it again, it could be that simple.
Hi Ucaihc,
It's not worth trying to diagnose the problem at this point.

For both front-end and backend, create a new empty database and import all objects into the new one.
Put the backend into its correct location and relink the front-end; redistribute the new front end.

If you stil have problems, then you will have to inspect the data in the backend, table by table to see if you can spot any corruption (usually indicated by #deleted in the data).

UcaihcAuthor Commented:
Yes, I made a copy of the backend and linked the tables in the front end to the copy. It seems to work. Is that Ok for now?
You should check the contents of the backend tables, at least by looking at record counts and comparing those with the old backend counts.
Make sure you retain your old backend as a backup in case you discover problems later on.

I can't say whether this has fixed the problem.  Only time will tell.
If you get recurring problems you have to try other things to diagnose the cause.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now