By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,828 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,828 IT Pros & Developers. It's quick & easy.

Wrong precision when linked to a SQL Server view

P: n/a
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

Sep 6 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.