[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1802
  • 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.
0
Ucaihc
Asked:
Ucaihc
  • 2
1 Solution
 
VB_ARGHCommented:
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.
0
 
peter57rCommented:
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).


Pete
0
 
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?
0
 
peter57rCommented:
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.


Pete
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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