Share via

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

Mh Ashik 0 Reputation points
2025-12-12T14:14:12.06+00:00

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

Microsoft 365 and Office | Access | For home | Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2025-12-12T14:37:23.9+00:00

    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.

    Was this answer helpful?

    0 comments

  2. AI answer

    2025-12-12T14:14:25.2033333+00:00

    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:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.