Wrong precision when linked to a SQL Server view

  • Thread starter Thread starter Joep
  • Start date Start date
J

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
 
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
 
Back
Top