ODBC and me

[michaelskis]

Our staff GIS person and I where wondering about the possibility of having links between a code enforcement data base in Microsoft Access and our ArcGIS (8.3). But the question is how do we go about it with out recreating our database. We where kind of thinking about using an ODBC and Geo database. What information can you TECH people share with me?

 

[Repo Man]

You should be able to join the tables by a common field like tax key/parcel ID.

 

[Budgie]

Although you'd have to periodically export and import, you could export the access database to an excel spreadsheet and import to your GIS provided you have a common field, typically the parcel id number.

 

[Rumpy Tunanator]

You should be able to join the tables by a common field like tax key/parcel ID.

Repo Man has got it. We recently connected our traffic signal database in Access to ArcView, so a layer can be put on maps for signal locations. Although aren't they phasing out Access and implementing a new similar application?

 

[michaelskis]

so no matter what I would have to do updates to the map on a regular basis?

 

[Repo Man]

No, with the link, you should be able to update your code enforcement stuff and the link to the Geodatabase would automaticaly update your data.

You shouldn't have to update the map at all. Your database will update the map for you.

 

[Chet]

Are you running ArcSDE?