I have some tables in a MicroMine project that are linked to tables in Access. In the Access tables, numeric values are stored as text. When I first created the links I decided that the numeric values should be loaded into Micromine as the Float type. The link form let me set it up that way, no problem. Micromine indicated that the links were successfully created. However, when I looked at the linked tables in MicroMine, none of the numeric values had been loaded.
I decided to set the link form to bring in the numbers as type Real. That didn't work either.
Finally I tried to bring in the numbers as type Numeric. That worked.
Does anyone know why I couldn't bring in the numbers as Floats or Reals? And, if there's some fundamental reason why that can't work, shouldn't MicroMine tell me that the link was unsuccessful, instead of saying it was created successfully?
I'm using MM 2016 SP 3 on a fully updated Windows 10 machine.
Customer support service by UserEcho