SQL Views linked to Access

[Ernie Laitinen]

We are trying to use SQL views from our SQL server 2003 files and link them
for Access reports.

They are bringing across data that is in a numeric 16.4 field and Access is
changing it to a text format.

Since the data dictionary is linked, it is difficult to manage.

We have found that we can do a cast function in the view to make it work
correctly, but that's a real pain.

Any other solutions?

Thanks,