cant find geography in data types option . what can i do for that ?

If you cannot find the geography data type in your data types options, it may be due to the specific database or environment you are using. The geography data type is supported in SQL Server and Azure SQL Database, but it may not be available in all contexts or configurations. Here are a few steps you can take:

1. Check Compatibility: Ensure that your database version supports the geography data type. It is available in SQL Server and Azure SQL Database.
2. Review Documentation: Consult the documentation for your specific database system to confirm if the geography type is supported and under what conditions.
3. Alternative Methods: If the geography type is not available, consider storing geographic data as a pair of latitude and longitude values or using a varbinary column with well-known binary content.
4. Database Settings: Check if there are any settings or configurations in your database that might restrict the use of certain data types.

If you are using a different database system or a specific version that does not support geography, you may need to explore alternative data types or methods for handling geographic data.

References:

• Spatial Data Types Overview
• Spatial Data

Access does not support the Geography datatype. There are other SQL Server data types that are not or poorly supported.

The best thing is to process that data server-side, in stored procedures, and return results with simpler data types that are supported, such as text or number.

I have done this myself, where we created several sales areas and stored them as Geography data type, and wrote a stored procedure that took an address, and returned a boolean value that indicated whether the address was within any sales area or not. Access can execute the sproc (using a pass-through query) and receive the boolean value just fine.