Results 1 to 2 of 2

SharePoint Columns incorrect in Access

  1. #1
    IsmQ is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Posts
    5

    SharePoint Columns incorrect in Access

    Having an issue with a table in Access since adding a new column into linked SharePoint list. Basically, after the column "Name" was added in SharePoint, the linked table in Access seems to have merged two columns together. When I looked at the design, it has changed a column named "Quantity" to "Name1." Is there a way to solve this issue if the columns appear correctly on SharePoint side? Thanks in advance for help.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    5,894
    'fraid I don't know the exact answer because I don't use SharePoint, but I can tell you something that might be the cause, and if not, certainly won't hurt to fix. Never use a reserved name for any Access object or variable ("Name" in your example). See
    http://allenbrowne.com/AppIssueBadWord.html

    http://access.mvps.org/access/general/gen0012.htm

    https://access-programmers.co.uk/for...d.php?t=225837
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Sometimes I talk to myself - like when I need expert advice.

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

Similar Threads

  1. Replies: 0
    Last Post: 09-18-2017, 09:02 AM
  2. Replies: 0
    Last Post: 09-05-2017, 10:35 AM
  3. Connection String for MS Access Database incorrect.
    By mond007 in forum Import/Export Data
    Replies: 14
    Last Post: 10-21-2016, 08:42 AM
  4. Replies: 0
    Last Post: 05-10-2016, 10:45 AM
  5. Access Min Max Comparison Yielding Incorrect Results
    By MetalCheese in forum Programming
    Replies: 6
    Last Post: 12-06-2011, 04:29 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
  •  
Tech Forums: Microsoft Office Forums