Linked table to SQL Server

[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

 

[Guest]

Hi Daniel,

The first thing I would try doing is deleting the linked table, compacting
the Access application, and then re-establishing the link from scratch using
File > Get External Data...


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________