Skip to Content
avatar image
Former Member

"Unable to retrieve source records" error

Hi,

When I am trying to create the compound field for one of my Qualified tables, I receive the following error "unable to retrieve source records". I am using a file in access format as my source file. Does anyone know of a solution? Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Jan 31, 2007 at 03:51 AM

    Make sure the Access file is Updatable.

    You may get this error if the Access database is read only.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2007 at 03:30 PM

    Hi,

    My access file is updateable. Any other solutions? Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23, 2007 at 02:07 PM

    Was there any solution?

    I get the same error when using Excel as the source.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25, 2007 at 07:30 AM

    Hi Guys

    Try changing the location of the file, or try to create a new file with the same content.

    Hope this helps

    Vinod

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25, 2007 at 01:22 PM

    Nhan,

    Are you naming the fields in the source with the same name that the fields in the destination?

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2007 at 02:43 PM

    You are trying to create a compound field for a qualified table. Check to make sure that you are not using a "cloned" field to map to one (or more) of the non-qualifiers. Remove the clone and use the original fields for mapping to all non-qualifiers and see if this helps.

    David

    Add comment
    10|10000 characters needed characters exceeded