Pass-Through Queries/Link Manager

A

atrapp

Hello everyone,

I am working with some data in Access and getting unexpected results when I
query a table of data in SQLServer. The table has a datetime column from
which I would like to fetch along with data in other columns (including
another datetime column). The datetime column of issue shows that it is NULL
for some records, which is fine. However, those same NULL records end up
having a bogus date in them when pulled via an Access query. My query type of
choice is a pass-through query which just calls a view created in SQLServer.
The view correctly returns NULL dates where it should when I use the
SQLServer tool but when using Access, the dates are bogus. I tried updated
the base table using the Link Manager and that seemed to work when I ran the
query. Then, when I close out Access and go back in, I get bogus dates
again. Also, even though it seems that refreshing the tables via Link Manager
works, if i close out and try running the query on someone ele's PC, I still
get the bogus dates!

Any suggestions are greatly appreciated and more info will be gladly provided.

Thanks,
 
Top