Results 1 to 4 of 4
  1. #1
    Eddy Sincere is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2014
    Location
    Carson City, NV
    Posts
    114

    Error Code -1517 on a table while splitting the database

    I'm trying to work with a (very) old database that has never been split. I'm trying to perform the split but the error code -1517 gets thrown on a specific table. I looked up possible solutions and they all talk about compact and repairing/compacting the Front and Back ends to resolve the issue. Then, if that doesn't work, delete the link between the front end and back end.

    However, because the database isn't split I can't delete the link. Also, when I try to simply copy the table into the new Back End it throws the same error.

    Any thoughts or advice on what to do?

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,996
    Make sure all forms are closed.
    To guarantee this, hold down the SHIFT key while loading the database.
    Then try the split.

  3. #3
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,842
    1517 error can also relate to using reserved words in table or field names. If any of your names match the ones in this link, try changing the name

    https://support.office.com/en-us/art...7-da237c63eabe

    Alternatively it is possible the table has been corrupted. This can be caused by an unsplit db being shared by multiple users at the same time or if there was a power loss whilst an update was in progress for example.

    Can you open the table and view all the contents (i.e. scroll through the entire table)? If so can you copy and paste the records into another file such as an excel.csv file? If you can get that far, manually recreate the table in the new backend, then import the data from the .csv file

  4. #4
    Eddy Sincere is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2014
    Location
    Carson City, NV
    Posts
    114
    Thanks for the response, Ajax. I was hoping there was some magic trick I could do to fix the problem.

    The table uses some of the reserved words, but even after changing them the table still can't be copied. The DB is used by about 12 people simultaneously and has probably suffered multiple crashes over its lifetime. While every record is visible (scrolling top to bottom) I'm fairly positive the table has been corrupted in some way.

    Looks like an export and rebuild is the next step. Thanks again and have a great weekend.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 10-27-2016, 06:24 AM
  2. Replies: 3
    Last Post: 05-15-2014, 09:59 AM
  3. Database Splitting Error
    By SltPhx in forum Access
    Replies: 2
    Last Post: 08-01-2013, 04:11 PM
  4. Error when splitting database
    By blkmagic in forum Access
    Replies: 1
    Last Post: 09-30-2011, 04:55 PM
  5. Reserved Error -1517
    By Rick West in forum Queries
    Replies: 5
    Last Post: 12-10-2009, 02:12 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums