topic Re: Can an Access MDB be converted to a Personal Geodabase? in Data Management Questions

Can an Access MDB be converted to a Personal Geodabase?

RandyKreuziger — Tue, 11 Dec 2012 15:36:00 GMT

Can an MS Access MDB be converted to a Personal Geodabase? FYI, we are running ArcGIS 10.0. Thanks

Re: Can an Access MDB be converted to a Personal Geodabase?

JakeSkinner — Tue, 11 Dec 2012 15:48:19 GMT

Hi Randy,

Personal Geodatabases are Microsoft Access databases that can store, query, and manage both spatial and nonspatial data. See here. You should have no problem accessing a Microsoft Access MDB using ArcGIS 10.0.

Re: Can an Access MDB be converted to a Personal Geodabase?

RandyKreuziger — Tue, 11 Dec 2012 15:50:40 GMT

Hi Randy,

Personal Geodatabases are Microsoft Access databases that can store, query, and manage both spatial and nonspatial data. See here. You should have no problem accessing a Microsoft Access MDB using ArcGIS 10.0.

Hi Jake,
I wasn't quite clear in my post. I know that personal geodatabases are Access databases. What I'm trying to do is convert an non-pgdb into a pgdb but I don't see any option to do that.

Re: Can an Access MDB be converted to a Personal Geodabase?

VinceAngelo — Tue, 11 Dec 2012 16:05:12 GMT

You can copy the Access tables into a PGDB later on, but I'm pretty sure there is no mechanism to
"spatially enable" an existing Access database. Given the lack of PGDB support with 64-bit ArcGIS
Server 10.1, it doesn't seem like this has much future as an ideas.esri.com suggestion.

- V

Re: Can an Access MDB be converted to a Personal Geodabase?

JakeSkinner — Tue, 11 Dec 2012 16:07:43 GMT

You won't have to do any additional steps to convert you MDB to a PGD. For example, if I create a MDB in Access I can immediately begin to use this with ArcGIS. I can import/export feature classes, create tables, etc. with the database.

Re: Can an Access MDB be converted to a Personal Geodabase?

RandyKreuziger — Tue, 11 Dec 2012 16:12:34 GMT

You won't have to do any additional steps to convert you MDB to a PGD. For example, if I create a MDB in Access I can immediately begin to use this with ArcGIS. I can import/export feature classes, create tables, etc. with the database.

I tried that but I get the following error each time

ERROR 000210: Cannot create output L:\tmp\NRCS\soildata\clallam_incl_FS\soildb_WA_2003.mdb\soilmu_a_wa632
Failed to execute (FeatureClassToFeatureClass).

Re: Can an Access MDB be converted to a Personal Geodabase?

JakeSkinner — Tue, 11 Dec 2012 17:04:36 GMT

Try copying the MDB to your local disk and see if you receive the same error.