NearImpossible
Registered User.
- Local time
- Yesterday, 20:40
- Joined
- Jul 12, 2019
- Messages
- 225
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?
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?
Last edited: