Invalid Pointer error Writing to MS Access

Hi @markrmunoz 

Could you provide your log file or a screenshot of the error in the translation log (including a few lines before the error)?

Is it possible that you are trying to write NULL values to a column with NULL value constraints? That was the fix from this community post: MS SQL Server Non-Spatial Writer issues

Crystal 

Thanks Crystal,

The autonumber is refering to an ID# that is generated for each entry in Access. I’ve tried changing the field type to int for AssetID and still get the error. 

Microsoft Access Writer: Opening `C:\Users\MMunoz\Desktop\Service Card DB test.accdb' for write operation
Microsoft Access Writer: Read 1 DEF line(s).  Found 57 attribute(s)
Microsoft Access Writer: Data type `autonumber' of attribute `ASSETID' of feature type `SERVICES' is not supported for writing.  Attribute will be ignored by writer
Microsoft Access Writer: Failed to write attribute `Meter ID' of feature type `SERVICES'. Provider Error `(-2147467261) Invalid pointer'
MDB_ADO writer: An error has occurred. Check the logfile above for details
Microsoft Access Writer: Closing `C:\Users\…\…….\Service Card DB test.accdb' . Write operation complete
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Feature output statistics for `MDB_ADO' writer using keyword `MDB_ADO_3':
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                               Features Written
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
SERVICES                                                                     1
==============================================================================
Total Features Written                                                       1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Translation FAILED with 2 error(s) and 1 warning(s) (1029 feature(s) output)
FME Session Duration: 36.3 seconds. (CPU: 13.3s user, 3.4s system)
END - ProcessID: 41372, peak process memory usage: 258552 kB, current process memory usage: 157404 kB
MDB_ADO writer: An error has occurred. Check the logfile above for details
Program Terminating
Translation FAILED.
 

Hi @markrmunoz 

I just want to confirm a few things. 

Are you writing to a new table or an existing table?
If the table already exists, can you try importing the schema to the writer to see if this resolves the issue? Alternatively, you can try writing to a new table. 

Is the ID a numeric value? 
Is any data being written out to the database? If so, is the writer failing on the same feature? 

Could you also send a screenshot of the writer parameters. 
Thanks!