I am using Pyodbc to connect to access database
import pyodbc, arcgisscripting,arcpy
arcpy = arcgisscripting.create(10.1)
arcpy.overwriteoutput = 1
conn = pyodbc.connect(("Driver={Microsoft Access Driver (*.mdb, *.accdb)};"
"DBQ=C:\Projects\ProjectDatabases\MIA\PrimaryDatabase.accdb;"))
cursor = conn.cursor()
InputTransport = "C:\ProjectDatabases\GIS\SIWW_Data_Display.gdb"
def TransportationAccess(accdbtable1,gdbfeat1):
cursor.execute("delete * from " + accdbtable1) #clear table
#join Trans_NodeTypeDetails from geodatabase to Acces_Trans_NodeTypeDetails. Join fields NodeType and Stations
arcpy.joinfield_management((InputTransport+"\\"+gdbfeat1),"NodeType",accdbtable1,"NodeType","Stations")
TransportationAccess("Access_Trans_NodeTypeDetails", "Nodes")
Feature class in geodatabase (gdbfeat1 in code) is "Nodes"Table in MS Access(accdbtable1) is "Access_Trans_NodeTypeDetails"I am trying to join these two tables.and I get this error saying "Access_Trans_NodeTypeDetails" does not exist. It is the same same table that it is clearing in the previous line.this is the error that I getarcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Join Table: Dataset Access_Trans_NodeTypeDetails does not exist or is not supported
Failed to execute (JoinField).
Thanks,Priyanka