Is your Access front end an ADP or MDB?

The Access wizard has short comings (duh). Microsoft has a better migration tool at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .

Do you get the same results when the report is based on a table not a query?

You could create another table with all of the values required. then do a view or query with that table linked to your data table. Then query...

I have had that problem if the database schema has changed since the creation of the ODBC. You may try recreating the ODBC.

If you can do your link using an Access ADP, then the diagrams do come across. 

A quick way would be to use DTS or SSIS to tranfer the table to Access. 

I have seen this when the database schema has changed since the creation of the ODBC. 

If you still have your SQL Server 2000 instance still running you could use that DTS to go from 2005 to Access.

When you insert an image you can display a tif from a path from a file.

Thanks for the link.    Upon further test in my testing environment I did get unsatisfactory results.  

Lynn,

Thanks for directing me to previous posts, where I found a solution posted on 9/15/2006 by you.  The solution was...

If you know what you are doing and use it in the right way, Access is a very powerful tool.  I have seen terrible misuses of Excel, but I am...

As society and technology matures into more formalized processes, dependability increases resulting risk averse users.  This issue is related to the IT Cowboy article from May this year. 

Good points Mike.

Microsoft has SQL Migration Assistant at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .  I have better success with it than the wizard.