Skip to main content
Question

Invalid Pointer Error when writing to linked table in MS Access?

  • March 14, 2017
  • 1 reply
  • 38 views
R

Hi, I'm trying to write to a linked table in an MS Access database. I'm using FME Desktop 2015, the access database was created with Access 2016, and the table is linked to a SharePoint list. My Access writer in FME is using version 2007 and set to INSERT. When the access table is local (same attribute schema), it works fine, but when the table is linked to the SharePoint list, I get the following Invalid pointer error. Any ideas how I can try troubleshot?

Microsoft Access Writer: Data type `autonumber' of attribute `ID' of feature type `Daily Changes' is not supported for writing. Attribute will be ignored by writer

Microsoft Access Writer: Failed to write attribute `Title' of feature type `Daily Changes'. Provider Error `(-2147467261) Invalid pointer'

A fatal error has occurred. Check the logfile above for details

A fatal error has occurred. Check the logfile above for details

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

owen
Forum|alt.badge.img+1
  • owen
  • March 14, 2017

Hello. As it is a linked table, you need to use the Sharepoint writer, as the data doesnt reside in the access database. Owen

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.