Wrong precision when linked to a SQL Server view

[Joep]

Hi all,

In an Access 2003 db I have a linked table to a SQL Server view. This
view is based on a SQL Server table with a column defined as
NUMERIC(4,2).

When I create an Access linked table directly to the SQL Server table,
the column definition in Access is just fine.
When I create an Access linked table to the SQL Server view, then the
column precision is wrong, it will always be 3,1, instead off 4,2.

What can I do to make Access to correctly import the right column
precision?

Thanks, Joep

 

[Mary Chipman [MSFT]]

I'm guessing here, but it seems like Access isn't able to view the
schema. Try creating the view using the WITH VIEW_METADATA option and
see if that helps.

--Mary