Extracting Long String Field from SQL Server into Access Query/Rep

G

Guest

I have designed a report based on pass through Access Query that pulls
data(via ODBC) from SQL Server back end tables. One field in SQL table is a
memo text and the length is way over 255. I need to pull this filed as is
into my Access 2003 report. So far, the memo filed shows blank in my query
and, consequently, in my report. Any help will be
greatly appreciated.

Regards,
 
M

Michael Gramelspacher

I have converted only one Access database to SQL Server 2005 Express, so I am
speaking from almost no experience. I created views on the server and linked to
these views. The views serve as record sources for forms and reports. One view
is the record source for a report and has two memo fields. It works
beautifully. The datatype of the memo fields is nvarchar(MAX). The same view
is the record source for a form, and there is no problem updating the memo
fields.

Maybe link to a view instead of a table, and make the view the record source of
your report. Then it is easy.

Dim s As String
s = "your where clause"
DoCmd.OpenReport "YourReport", acViewPreview, , s
 

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

Extracting Long String Fied from SQL Server to Access 2003 5
Append to SQL Server 3
how to break apart a large table field into smaller ones in SQL 3
Query not working for SQL Server 2
Access Pass-through Query to SQL Server 6
ms access and SQL Server 4
Defining Text field sizes in destination Make-Table Query 3
Update pass through query of report recordsource 2

Top