Output Data (10) Error Code in Access

[lynnaberry]

I can no longer output data in to access. I get this error message:

Output Data (10) Error opening connect string: Microsoft Access Database Engine: The database you are trying to open requires a newer version of Microsoft Access.\3956 = -70255665

[Yoshiro_Fujimori]

@lynnaberry 

According to the documents of Microsoft and Alteryx below, Int64 data type of Alteryx may trigger the issue.

So you may want to change the data type of your output data from Int64 to Int32, and see what happens.

Good luck.

https://learn.microsoft.com: "Database you are trying to open requires a newer version of Microsoft ... says:

This issue occurs if you try to open a database that contains a table that uses the BigInt data type.

BigInt support was added to Access 2016. BigInt appears within the table's data type as Large Number.

https://support.microsoft.com: Using the Large Number data type says:

The Large Number data type stores a non-monetary, numeric value and is compatible with the SQL_BIGINT data type in ODBC.

Use this data type to efficiently calculate large numbers.

-(263) to (263)-1

https://help.alteryx.com/20223/designer/data-types#numeric-data says:

Int64 A numeric value without a decimal equal to 8 bytes, or -(263) to (263)-1

[lynnaberry]

Hello! Thank you for help. I checked and none of my data is Int32 or Int64