Reserved error -1517 in fields - ADO DAO RDO RDS

This is a discussion on Reserved error -1517 in fields - ADO DAO RDO RDS ; Hello! Yesterday I coded compact and repair to my database. I have a split database with 5 tables in the back end. Now when I run the code and the compact and repair in it and right after that open ...

+ Reply to Thread
Results 1 to 2 of 2

Reserved error -1517 in fields

  1. Default Reserved error -1517 in fields

    Hello!

    Yesterday I coded compact and repair to my database. I have a split database
    with 5 tables in the back end. Now when I run the code and the compact and
    repair in it and right after that open any one of the linked tables from the
    front end, I have fields in the table that say "#Error". If I check out the
    same table in the back end, it looks normal.

    If I don't run the compact and repair code the error doesn't occur.
    If I close the front end after running the code with the compact and repair
    of the back end and open the front end again, the tables don't have errors
    anywhere.

    What is going on? The error is "Reserved error (-1517): there is no message
    for this error".

    I do the compact and repair like this:
    DBEngine.CompactDatabase "path to backend", "same folder: temp.mdb"
    Kill "backend"
    Name "temp" As "backend"

    - Beginner -


  2. Default Re: Reserved error -1517 in fields

    Beginner <Beginner@discussions.microsoft.com> wrote:

    >I found this text from the web:
    >"The error is because a column ID is not valid in a linked table."


    The above is not quite accurate. It is more that you've inserted a
    field in the middle of a table, you've compacted the back end, and now
    the cached data in the linked table doesn't match the field data in
    the back end.

    Hmm, you likely got that from my website. It's a direct quote from
    Michael Kaplan though.

    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
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

+ Reply to Thread

Similar Threads

  1. Re: Error 50103 The specified Resource is Reserved
    By Application Development in forum labview
    Replies: 6
    Last Post: 11-27-2007, 03:40 PM
  2. Reserved Error (-3087)
    By Application Development in forum ADO DAO RDO RDS
    Replies: 5
    Last Post: 10-09-2007, 01:36 AM
  3. RE: Reserved error -1517 in fields
    By Application Development in forum ADO DAO RDO RDS
    Replies: 0
    Last Post: 08-16-2007, 08:09 PM
  4. Error in loading DLL: 'cdoConfig.Fields'
    By Application Development in forum Inetserver
    Replies: 1
    Last Post: 07-03-2007, 04:03 PM
  5. Error in Page with using SelectNodes for Contact fields....
    By Application Development in forum Microsoft Exchange
    Replies: 0
    Last Post: 09-15-2005, 03:10 PM