Wednesday 12 October 2016

Is it possible to edit a layer from Esri Personal Geodatabase in QGIS 3?




After a lot of research and effort I have successfully made a connection to my Esri Personal Geodatabase (.mdb file).


Now I want to edit some attribute data in the attribute table of a layer... BUT I can't because the toggle edit and the editing toolbar is greyed out.


So how do I edit a layer inside (.mdb) file that I have loaded into QGIS?!


I am using QGIS 3.


Don't ask me why I want to do it this way. (But If you wan to know why, it's because I want to edit the (.mdb)file in QGIS and then send it to someone who is using ArcMap who should be able to read/write to the file too. The other person has ArcMap and I have QGIS).



Answer



The bottom line here is you can't. Here's a list of files you can edit within QGIS. As you can see, .mdb files are not in there, because OGR/GDAL don't handle writing .mdb files (they only support reading).


If you're working with someone using Esri software, you could ask them to convert the files to a format you can both work with. Or you could save the .mdb layer as a format that you can edit, like shp.


Either way, you unfortunately have to change the format.



No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...