Solved Not all data copying over (1 Viewer)

[NearImpossible]

I have a table in a SQL backend with a column set as nvarchar(MAX) that has a string of characters that is 402 in length.

I have a query that runs to create a new local table on the access front end and copy the specific info in it, however for some reason it is only copying over the first 255 characters of that field.

After the table is created, I can manually copy the data from the SQL table to the local Access table without issue, however when running the macro to create the table, it only pulls the first 255 characters.

When I look at the table properties, it show that field as Long Text.

any thoughts?

 

[theDBguy]

Hi. Can we see the VB code please?

 

[NearImpossible]

Actually I am wrong on the above, sorry about that. I edited the first post

My query runs regardless of the results, as stated before its a Make Table Query and copies over several fields from a few different tables into the one table, however it cuts that one field short

 

[NearImpossible]

So while looking around on the web, I came across an article that says if you are returning Unique values, this can cause Long Text fields to truncate.

I did have Unique Values set to Yes, changed it to No and now it is bringing everything over.