I have a table on SQL server with fields defined with the following data types:
Column Name Data Type PK/FK id numeric(38,0) PK, FK field1 varchar(56) field2 numeric(38,0) PK, FK field3 varchar(56) field4 date field5 date
After linking to this table from Access, when I select "Design view", all of the data types in Access show as Text
The source data in SQL server for column ID contains only numeric entries, as enforced by the data type.
In my Access Options, under Object Designers, for table design view my default field type is Text. I can understand VARCHAR being mapped to TEXT. However, based on the data mappings from Microsoft (http://office.microsoft.com/en-us/ac...41762.aspx#BM4), NUMERIC should map to NUMBER.
Why is this happening? How can I correct it?