Query problems

[Daniel.Ran.XU]

Hi guys,

I got a problem for Access and SQL Server.


I got a DB in Access which has two similiar tables linked from SQL
Server. Both table has a field stored bitmaps with OLE. The two
tables
are exactly same except the data. When I use queries to display
maps,
one of them works all right but the other just freezing. If I use an
other mdb file to store the maps. It works fine. What's the possible
reason?


I need your help!


Cheers
Daniel

 

[S.Clark]

Could be corrupted. Remove link, re-link, Repair and compact.