MS Access Text(1) data type

[arusoft]

We have a ms access table in following format.
CREATE TABLE TestTable ([f1] long,[f2] text(200),[f3] long,[f4] text(1),[f5] text(1),[f6] text(1),[f7] text(1),[f8] text(4),[f9] text(1),[f10]text(1),[f11] text(1))

I has 300 rows and data in all the columns.

But when I use TuniConnection & TUniQuery , I only get data in first 4 columns.

I think uniQuery is not able to handle fields of type text(1) properly. It is able to show the first field of type text(1). There after its not showing data for columns of any data type.

Please advice.

Thank you.

[AlexP]

Hello,

We cannot reproduce the problem - data from your table is displayed in all the columns. Please try to reproduce the problem on the latest UniDAC version 5.2.5

[arusoft]

Thanks for the update.I will update & let you know. But right now we are using 4.6.11.

Regards.

[AlexP]

Yes, indeed, this problem is reproduced in old UniDAC versions, however, in the latest UniDAC version 5.2.5, data is displayed correctly in all the fields.

[arusoft]

Looks like we need to buy upgrade to get latest version. We are in process of doing that. Will update once I test again with latest version.

[AlexP]

If you encounter any issues with the latest UniDAC version, please contact us again.

[arusoft]

So we upgraded to latest uniDac and this is looking much better.

Thank You.

[AlexP]

You are welcome. Feel free to contact us if you have any further questions about UniDAC.