By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,733 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,733 IT Pros & Developers. It's quick & easy.

Reading a SQL Server text field using a connection.OpenRecordSet

P: n/a

I am trying to read a SQL Server text field (Access memo field) using

connection.OpenRecordSet("qry with text field") [ODBCDirect]

rather than

database.OpenRecordSet("qry with text field") [Microsoft Jet]

When I use the connection.OpenRecordSet command, my incoming text field
cannot more that 500-odd characters, otherwise the query bombs. This
isn't the case for database.OpenRecordSet.

Is there something that I can do when I open the connection to make the
SQL Server text fields Access receives in a query longer than 500
fields? Maybe a property on the workspace? The queries with
connections are naturally much faster than with databases.


Jan 26 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.