Weird linked SQL Server table problem

E

es330td

I have a SQL Server view linked as a table in an Access 2003
database. One of the columns (FisYearName) in the view coming from
SQL Server is an nvarchar field although the data returned is a 4
digit year.

I have written a query in Access,

SELECT CInt([FisYearName]) AS FisYear,
dbo_vCIPBudgetEscalationCalculations.*
FROM dbo_vCIPBudgetEscalationCalculations
WHERE (((CInt([FisYearName]))>2012))
ORDER BY CInt([FisYearName]);


On my machine, running version 11.6566.8132, when I run this I get the
records having a fiscal year greater than 2012 and ordered by the
FisYearName column. On a coworker's machine running 11.6566.8172,
when he runs it not only does he get back every record in the table,
they are not in order by FisYearName.

We don't know if this a problem specific to .8172. We also don't know
if we can just copy my .8132 version over his .8172 and have his
system not break.

I am not sure if I am even looking in the right places to figure out
what is going on but if anyone can shed any light on this I'd love to
see it.
 
Top