priyanka_mehta

Join field in feature class to field MS Access table 2007 format

Discussion created by priyanka_mehta on Aug 16, 2013
Latest reply on Aug 26, 2013 by priyanka_mehta
Hi,
I am trying to join fields from a feature class in geodatabase to a field in MS Access database.


This statement used to work fine for 2003 format of ms access but for 2007 format it gives an error
gp.JoinField_management(gdbfeat1,"gdbField1",accdbtable1,"accField1","accField2")

arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Join Table: Dataset tablexxx does not exist or is not supported


although it clearly exists and it is being able to do execute other statements like
cursor.execute("delete * from " + accdbtable1)  which is inside the same loop.  

Can somebody please point how should I join fields from geodatbase table to ms access table.

Thanks in advance,
Priyanka

Outcomes