I agree that maps are extremely helpful but don't discount the table information. In my case, I maintain a speed zone database with DFOs (distance from origin of a roadway... example, where I-10 enters Texas at El Paso =0.000 and where it leaves Texas at Houston = 879.499) which I use in conjunction with pre-established roadway layers to plot the speed zone lines. My data is much easier to maintain in Access because, when a speed zone is changed, I can run reports for a specific roadway and change out /delete the appropriate line(s) and then the next time I open my map, the layer is updated. Also, I send the Access reports (not maps) to our consultants because speed zones are not established by physical location. They are established by control-section and mile point (which aren't relevant to the shape file except when I convert them to DFO (distance from origin) to map them. In short, the map is useful for big-picture but I still need to maintain a file database to keep my records straight. If there's a file database that is more compatible, please tell me and I'll see if I can get it (since our downloads are all controlled by our IT department, I can't simply download a free program). Any help would be appreciated.
... View more