ACC: Linked SQL Server Binary Data Displayed Incorrectly

MORE INFORMATION

Steps to Reproduce Problem

1. Use one of the following two methods to create an SQL table called TMS:
   

      Method 1:
   
      Create the following script table on a SQL Server:
   
         create table tms(i int, b binary(8))
         go
         create unique index idx on tms(i)
         go
         insert tms values(1,0x3939)
         insert tms values(2,0x00019d01)
   
      Method 2 (In Microsoft Access 2.0, 7.0 and 97 only):
   
      Create a pass-through query and run the following commands, one at a
      time:
   
         create table tms(i int, b binary(8))
         create unique index idx on tms(i)
         insert tms values(1,0x3939)
         insert tms values(2,0x00019d01)
   						

2. Link the resultant table in Microsoft Access and view it in Data- sheet view. Note that the data in the first row is displayed as "99," and that nothing is displayed in the second row. (The second row actually contains unprintable characters that you cannot see.)