error output to an Access DB - record is too large

Dear Community,

The output of an wf goes into an Access DB (I overwrite the table every time). I have tried with both mdb and accdb and I get the following error:

Error: Output Data (51): Error creating table Table1: Microsoft Access Database Engine: Record is too large.\3047 = -67175426CREATE TABLE "Table1" and all the fields are shown.

I have changed the Type and Size of the fields to String (less than 100) and Fixed Decimal, but no luck. What could be the issue?

I want to run the Workflow also on the Alteryx Server.

Thank you in advance for your help,

DAM

Datasets

Accepted answers

afv2688

Just install the software on your machine. On the output tool select then SQL server and configure the connection. If the connection was a success everything should go smoothly from there on.

All comments

danilang

hi @DAM

Depending on the structure of your data, you may be hitting this limit

Number of characters in a record (excluding Long Text and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes

4,000

Source

Dan

DAM

Hi danilang,

It seems that when I refershed the data, the Access DB exceeds 2 GB (although the data that I have it is not so big - aprox 1 mil records). The funny thing is that it worked before.

How can I overcome this? Also, I need an output file that works better, and in the same time to feed a pivot in excel.

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703