We have some Access 97 reporting databases which use pass-through queries to access some SQL Server 2000 databases. The databases have historically been accessed through Win 95 or 98. We have been upgrading some servers to Win 2000 which is when the problem started.
We have come across a strange problem recently whereby SQL Server "money" fields do not appear in query results on the Win 2000 servers. The data is definitely there, as if we change the SQL to say "CAST(field as REAL)", the data is shown.
The Win 95/98 machines still display the data correctly. It seems as though there is a conflict between Windows 2000 and SQL 2000 or Access 97.
Unfortunately, for us to change every single pass-through query (some of which are built in code) to specify "CAST AS REAL" would be a huge job.
Does anyone know of any settings on Win2000/Access97 that we need to update or any other solutions ?
Thanks
We have come across a strange problem recently whereby SQL Server "money" fields do not appear in query results on the Win 2000 servers. The data is definitely there, as if we change the SQL to say "CAST(field as REAL)", the data is shown.
The Win 95/98 machines still display the data correctly. It seems as though there is a conflict between Windows 2000 and SQL 2000 or Access 97.
Unfortunately, for us to change every single pass-through query (some of which are built in code) to specify "CAST AS REAL" would be a huge job.
Does anyone know of any settings on Win2000/Access97 that we need to update or any other solutions ?
Thanks
