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

Posted on 2006-03-27
Last Modified: 2011-10-03
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.
Question by:Ucaihc
    LVL 1

    Expert Comment

    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.
    LVL 77

    Accepted Solution

    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).


    Author Comment

    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?
    LVL 77

    Expert Comment

    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.


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now