Advice on building a geodatabase from a Microsoft Access database

Discussion created by kpzimmer on Sep 8, 2011
Latest reply on Oct 5, 2011 by kpzimmer
Hello all,

I have a few Microsoft Access databases that I would like to convert to geodatabases or at least include some spatial components; however, I have little experience with geodatabases.  Currently, my Microsoft Access database is organzied into several heirarchial tables that are connected through relationships in Access. Example table structure and relationships are shown in the attached photo:

This structure works fine for organizing and managing non-spatial attribute data, but now I'm hoping to integrate a spatial component for the conservation site, sample site, and plot paramters . For example, I have a Conservation Site polygon feature class, a sample site polygon feature class, and a plot point feature class. No spatial components are required for the ground, tree, and shrub subtables, but these tables may have further lookup tables associated with them.  My question is can I integrate these 3 feature classes into this structure and if so how do I go about doing this?  In the end I would like to be able to view the points or polygons in ArcGIS and see the underlying attributes of all the subplot tables in ArcGIS, but still be able to edit and append attribute data though a Microsoft Access form and create Microsoft Access reports using the attribute data. Addtionally, in the future I'll need to add additional conservation sites, sample sites, and plots so please keep this as a consideration as well.

Any input, advice, or links to further information on this topic would be greatly appreciated.

Thanks in advance.