File vs Machine DSN
Posted on 2007-10-16
I am migrating (upsizing) an Access 2002 Access database to Access 2007. Data is in SQL Server 2000. Has a lot of precise numeric data (16 decimal places). In the old version I used a file dsn for the ODBC link - worked great - no issues having dsns configured onto PCs etc....
When I migrated to Access 2007 (staying with SQL 2000) I created a new file dsn and used the convert functionality to create an accdb file. Numeric data on showed to 2 decimal places. I could format the field to 16, but would show as rounded to 2 deimal places with 14 further zeros!
I have created a machine dsn, and data links happily. I've checked the dsn settings and they are exactly the same. Can anyone explain and/or provide a way to make file dsn work?