Windows NT & XP pro

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

I have a query that I have been running on Access 97
running in a NT enviroment that works fine. The query
involves several tables, some of which are linked from a
SQL database.

Whenever I attempt to run this query from my box running
XP Pro, the query results with no data.

When I switch to my NT box, the query results with 20 or
so rows of data.

I am running the same query, I am just accessing it from
two different boxes.

Does anyone have a clue as to what the problem could be?

Thank you,

Fred
 
I have seen something like this (though in reverse) between XP and
Win2000, with both systems running Access 2000. My problem turned out
to be caused by a Custom Function returning a Date to a Query column
as a Variant. From memory (it was a while ago) it worked fine on the
XP system but the return value was being treated as a Null (or at
least a non-Date!) on the Win2000 systems. If your 20 records comply
with a specific Select criterion, remove it temporarily from the Query
on the XP box and see what is appearing in that Column of the Query.
That will hopefull give you a cluse as to what is happening.


I have a query that I have been running on Access 97
running in a NT enviroment that works fine. The query
involves several tables, some of which are linked from a
SQL database.

Whenever I attempt to run this query from my box running
XP Pro, the query results with no data.

When I switch to my NT box, the query results with 20 or
so rows of data.

I am running the same query, I am just accessing it from
two different boxes.

Does anyone have a clue as to what the problem could be?

Thank you,

Fred
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top