How to write to .accdb?

[KatharinaPalffy-Gelfand]

Hi,
I have a script that writes data via an InsertCursor to a .mdb. Now that .mdb has been changed into an .accdb and my script does not work anymore. It is giving me an IO error that a specific table is not found. When I look in my .accdb, the table is there.
Do I need to connect to this new .accdb with the help of pyodbc? Does a regular insert cursor work then?
Your help would be appreciated.

[MichaelVolz]

Are you storing data in a personal geodatabase?  Are you running on a machine with a 64 bit operating system?

[KatharinaPalffy-Gelfand]

Hi Michael,
yes, I am on a 64-bit operating system. Windows 7 Enterprise.
The data is stored in a file geodatabase.

[MichaelVolz]

In your initial post you wrote about an insert cursor to a .mdb which I believe is a personal geodatabase, but in your next post you said file geodatabase.  Is it a personal or file geodatabase?

There was a thread about ESRI migrating away from personal geodatabases, so you may want to convert your .mdb to a file geodatabase (.gdb) and then run your script.

Look in the middle of this forum post for info from Mathew Coyle about personal geodatabases

http://forums.arcgis.com/threads/86999-Select-by-Attribute-and-Calculate-from-old-AML

[KatharinaPalffy-Gelfand]

Hi Michael,
sorry to have confused you. Let me elaborate. I have a spatial database (file geodatabase) with my feature classes. Now I want to use arcpy.InsertCursor to write certain information from my feature classes like area and length to tables in an access database (.accdb). My question is: Do I need to connect to the .accdb first and can I then use arcpy.InsertCursor to write that information to it?

[MathewCoyle · Accepted solution]

Katharina,

Try reading through this link. The short version is you should connect to it first using pyodbc or some other method before you access it.
http://support.esri.com/fr/knowledgebase/techarticles/detail/32976