If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data not being display in Access Report via an ODBC Connection
I am having difficulty creating a report. The report is not
displaying/showing any data for a particular control/field. Here is my scenario information: Access 2003 using 2000 format; SQL Server 2000 Enterprise Edition. I have an ODBC connection defined using the sa account name. The ODBC connection test okay. I am trying to create a report using Access. The report record source is equal to the linked table. I used the fields list to obtain the controls I wanted to be displayed on the report. Data is being displayed in all of the controls/fields with the exception of one. I looked at the linked table properties for the particular field that is not displaying any data. Access has defined the field data type of “OLE object”. I examined the corresponding SQL Server table and field and found the data type to be “Image.” I understand the actual data is text--“rich text format file.” What do I need to do to get this text be displayed in my report? If this is not the correct place to make this type post, let me know the correct access group. Any help would be greatly appreciated. David S |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Access Pages lose data connection | Tom J | General Discussion | 0 | September 15th, 2004 08:22 PM |
Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
Access Calendar | lost | General Discussion | 2 | July 7th, 2004 04:58 AM |
Data Access Page Problem | Doug Munich | General Discussion | 0 | June 5th, 2004 12:03 AM |