Trouble reading varchar columns from SQL Server.

A

Amy Tex

HI, All, I am using an MS Access Project to connect to SQL Server. BUt I am
having trouble to read varchar column which is longer than 256 characters.
Basically, in the text box that I use to display the data, it keeps repeat
the first 256 characters until it reaches the length of the data in the SQL
Server. Can anybody help me on that? Thanks a lot.
Amy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
How do you capture the value of a local variable from SQL Server? 4
Getting string from database table with VARCHAR(MAX) field 0
Append to SQL Server 3
Reading SQL Server Extended Properties 0
ADO and Large Varchar truncated to 255 chars 3
Truncating SQL Server "Text" field 5
connecting to Sql Server Express 2008 64 bit 1

Top