Loading…
NEARC Fall 2017 has ended
Welcome to the interactive web schedule for the 2017 Fall NEARC Conference! For tips on how to navigate this site, visit the "Helpful Info" section. To return to the NEARC website, go to: www.northeastarc.org/fall-nearc.html
View analytic
Monday, November 6 • 10:30am - 11:00am
User Session. Life After VBA and MDBs

Sign up or log in to save this to your schedule and see who's attending!

AUTHORS: Don Katnik*, Maine Department of Inland Fisheries and Wildlife

ABSTRACT: It turns out that Esri was serious about getting rid of VBA. With version 10.4, my last few custom tools imploded with spectacular application crashes (sorry for the inconvenience!). So, what now? If there is anyone else left out there who has not migrated away from VBA, this presentation will demonstrate a less-painful-and-expensive-than-imagined path forward using Visual Studio (because - "let’s be honest" - as powerful as Python is, its GUI capabilities just don’t compare). Concurrent with my GUI needs I also have many scripts and tools that query data tables. These were written originally for Access MDB files that now will be migrated to the “new” ACCDB format (I know! They’re only 10 years outdated) and, finally, to SQL Server (everyone smile and nod approvingly). Rather than rewrite code embedded in dozens of Python scripts and Arc tools I created a Python module specifically for querying tables that will handle shapefiles, file GDBs, Access MDBs or ACCDBs, and SQL Server. It seems to work and maybe some of you will find it clever and want to copy it, OR (more likely) you will have much more elegant ideas for how to accomplish the same thing and may feel inspired to share them during the Q&A. So I will present what I’ve done and see what happens.

Monday November 6, 2017 10:30am - 11:00am
Ballroom Salon II (3rd Level)

Attendees (12)