Cannot Link to SQL Server Table that contains the Float Data Type (1 Viewer)

[ions]

Hello Access World,

I am storing Lat / Long from GoogleMaps API in SQL Server. It is recommended to use the Float Datatype to store Lat / Long, however, when I use Float MS Access presents me with the following error when I open the Linked Table.

When I store Lat / Long as Decimal(9,6) access linking works well.

I can accept the extra storage for the Decimal datatype but I wanted to understand if this is the best approach to resolve this issue.

Thank you.

 

[arnelgp]

maybe use Double datatype.

 

[Isaac]

maybe use Double datatype.

In sql server?

 

[GPGeorge]

Hello Access World,

I am storing Lat / Long from GoogleMaps API in SQL Server. It is recommended to use the Float Datatype to store Lat / Long, however, when I use Float MS Access presents me with the following error when I open the Linked Table.

View attachment 116234

When I store Lat / Long as Decimal(9,6) access linking works well.

I can accept the extra storage for the Decimal datatype but I wanted to understand if this is the best approach to resolve this issue.

Thank you.

Sometimes, what just works is the "best" approach. At least until something better comes along.

 

[ions]

OK, I'll stick with Decimal(9,6).

Thank you everyone.