How to embed map into access database?

Question

I am developing a database for my organisation that could be spatially enabled. I have to use MS Access 2007 on Windows and am therefore looking for any possibilities to encorporate my access DB into a mapping tool to embed inside my access application.

Has anyone successfully created an MS Access project which embeds a mapping window? I would ideally like to simply geocode my datasets - digitize a point after inputting my data into the db.

If anyone can shed any light on whether this is possible I would be grateful.

Answer 1

If you have Access 2010 you can do this:

http://www.youtube.com/watch?v=GHoy6hsAltc

If not, then perhaps one of these links may help:

https://groups.google.com/forum/?fromgroups=#!topic/microsoft.public.access/jZnlHxayF_g

http://www.utteraccess.com/forum/Call-MapQuest-access-t582734.html#Post582734&Zp=

http://bytes.com/topic/access/answers/211734-using-google-maps-ms-access

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22597280.html

Answer 2

ArcGIS and MapInfo are using the Access File Format (2003) to store their data. you can manage and access your data (not views) from both ArcGIS/MapInfo and MsAccess