I am using Access 97 to link to SQLServer 2000 sp 2

When I link to a table with data defined as numeric or decimal Access sets this data type as text in Access.

The only thing that I can do (that I know of) is to set all of these values as currency, but this is not a good solution as it will confuse my clients.

Is there any way to do this in Access, do I need to be in a differenct version of Access to get around this problem, or is the problem corrected in SqlServer 2000 sp 3 ?

Thanks a lot