Integrating ACCESS database files with GIS files

[Philip Hurvitz]

The most flexible way I've seen for dealing with this is to use the shape
file in AV.  The shape file is point, line, _or_ polygon (sorry, folks,
there is no line + poly shape, as with coverages).  However, the attribute
data in a shape file are stored in a standard dBase (IV?) file which can
be used in Excel, Access, etc.  In Access, you will need to save your
Access table as a dBase file.  Then link this dBase file into your Access
mdb.  Some initial testing (you should verify this on your own) is that
the same dBase file, opened in Access and AV at the same time, can be
edited in either application, and the changes are updated in real time.


-P.

***************************************************************************
 Phil Hurvitz | GIS Specialist | College of Forest Resources | 355 Bloedel
Box 352100 | University of Washington, Seattle, Washington  98195-2100, USA
 tel: 206.685.8179 | FAX: 206.685.3091 | e-mail: phurvitz at u.washington.edu 
             WWW: http://weber.u.washington.edu/~phurvitz/
***************************************************************************

On Mon, 31 Aug 1998, Joan E. Robertson wrote:

> Hi Everybody,
> 
> I have one big ACCESS database broken up into 3 tables each with about
> 1000 records, and growing rapidly.  I need to get it to work with ARC
> VIEW.
> 
> It will be updated regularly.  So I need a way to convert it easily to
> an ARC format that I can 
> 
> I need to be able to call and display data from the ACCESS files in
> ArcView, and to make SQL calls combining the ACCESS data with other data
> in the GIS.
> 
> Does anybody know how to do this, or if it is even possible?  My book and
> the help files don't seem to cever this one.
> 
> Thanks.
> 
> *******************************************************************************
> Joan E. Robertson Ph.D. 			Office #: I-713
> Research Associate				Mailstop #: 357330
> Regional Primate Research Center		Phone #: (206) 616 4310
> University of Washington			Fax #: (206) 685 8606
> SEATTLE, WA 98195				Email: joan at u.washington.edu
> *******************************************************************************
> 
>