referencing a table from a .mdb file

WayneHajas — Wed, 30 Nov 2011 14:53:20 GMT

I am working with join and relates commands.

In the GUI, I can reference tables from a .mdb (microsoft access) file. I would like to be able to do the same from a python script.

Instead of arcpy.AddJoin_management( "veg_layer", "HOLLAND95", "vegtable.dbf", "HOLLAND95"), I would like to use something like arcpy.AddJoin_management( "veg_layer", "HOLLAND95", TABLEinMDB, "HOLLAND95"). I just have no idea what the syntax for TABLEinMDB would be. Does anybody have any ideas?

As an aside, is there some sort of feature logging feature in ARCGIS that would help to sort out these types of issue?

Thanks in advance!
Wayne

Re: referencing a table from a .mdb file

JamesHood — Sat, 11 Dec 2021 08:26:04 GMT

For example

import arcpy

#Option1
MDB = "c:\temp\tables.mdb\"
table = "vegtable" 

arcpy.AddJoin_management( "veg_layer", "HOLLAND95", MDB + table, "HOLLAND95")




#Option2
TABLEinMDB = "c:\temp\tables.mdb\vegtable"

arcpy.AddJoin_management( "veg_layer", "HOLLAND95", TABLEinMDB, "HOLLAND95")

Note: should not require the table end in .dbf if it is located within a .mdb.

topic referencing a table from a .mdb file in Python Questions

referencing a table from a .mdb file

Re: referencing a table from a .mdb file