A Personal Geodatabase is an ESRI-specified GIS database, in Microsoft Access (.mdb) format.

learn more… | top users | synonyms (1)

2
votes
1answer
26 views

Self-intersecting after exporting .shp from Personal GeoDatabase

I have a Feature Dataset in a Personal Geodatabase, with resolution = 0.00000001 and tolerance = 0.000000005. I am exporting the Polygon Feature Classes to shapefiles, after setting Resolution = ...
2
votes
1answer
64 views

Transfer data from access mdb to personal geodatabase (OLE, Python scripting)

I am very new in Python. And I guess I need to use lots of Python here. I have MS Access 2003-2007 database (mdb format) and personal geodatabase (mdb). I created a tool in Access that imports data ...
1
vote
1answer
43 views

Link Excel Table to Access/Arcmap Personal Geodatabase Table

My overall goal: My coworkers have an excel table which they update/use frequently. The table is not in a format that arcmap can decipher. Therefore, I've created a locked sheet (in the format I ...
3
votes
1answer
36 views

How to find Coordinate System of datasets inside MDB and GDB

I have been given some ESRI personal geodatabase files (MDB) and file geodatabase files (GDB). I don't know the coordinate system(s) for these files. Is there a way to do this without using ESRI ...
2
votes
1answer
72 views

Personal geodatabase items have an exclamation (!) in ArcMap

A user in our department is having a problem accessing personal geodatabase data in ArcCatalog and ArcMap. Receiving error message: Failed to connect to database. An underlying database error ...
0
votes
1answer
33 views

ArcGIS Select largest N rows in group

I have feature class (Name: V1) in personal geodatabase with columns: Height [float] and Id [int] representing group number I need to do SQL query that will select eight highest 'Height' values in ...
2
votes
2answers
57 views

ZIP and import to ArcGIS online a personal geodatabase

This may sound dumb, but how do you zip a personal geodatabase in order to import it to ArcGIS online? Are there other ways to import the geodatabase, different from the one below? ArcGIS Online ...
5
votes
1answer
253 views

Using Python to discriminate Personal Geodatabases and MS Access Databases

I need to list a server's geodatabases, to analyze and process them. My users are however creating both personal geodatabases and MS Access geodatabases. Listing mdb files reports both types of ...
0
votes
1answer
46 views

Creating new layer from selection in ArcPy? [closed]

arcpy.SelectLayerByAttribute_management() helps in selection but I am unable to create a new layer from the selection arcpy.MakeFeatureLayer_management() for generating new layer file but it gives an ...
2
votes
1answer
49 views

Does it matter whether I use ArcCatalog or Access to compact a geodatabase?

I've been tasked with compacting some of the personal geodatabases (MDB files) in our office every few weeks. These reside on a couple of separate file servers. I have been using ArcCatalog to do ...
2
votes
1answer
69 views

How to correctly use ArcObjects to search or to obtain a count (IQueryFilter) from a selection set?

This only appears to be an issue with Personal Geodatabases (MS Access back end)... I need to search within an existing selection set to populate an ICursor. My main objective is to test whether my ...
1
vote
1answer
41 views

Problem using ogr2ogr to convert postGIS table to personal geodatabase

I need to convert a PostGIS table to a personal geodatabase using ogr2ogr. I can convert tables to a shapefile without a problem but whenever I try to convert it to .mdb using the ODBC driver, I get ...
1
vote
1answer
32 views

Cannot find table in geodatabase

I was using the Make Query Table tool in ArcGIS. Once the tool finishes running, the result (a table whose name I specify) is automatically added to the Table of Contents and I can view the data ...
1
vote
1answer
46 views

What data format to do temporary editing with QGIS before committing it to a RDBMS?

I am trying to create a temporary spatial data from a PostGIS database that a user can do the editing on. Currently, I have a service that returns GeoJSON from the PostGIS database. But I don't think ...
1
vote
1answer
142 views

How to copy attachment feature class from personal GDB to File GDB?

I have some feature classes with attachments in personal geodatabase . I want to copy these from personal to file geodatabase automatically using arcpy. I used the code suggested by @Aaron to copy ...
1
vote
1answer
84 views

Determining local geodatabase release version with arcpy?

Can anyone get the release version of a ESRI local geodatabase, using arcpy? I should be simple, and yet... I use the "Describe" function on both personal and file geodatabases, and need to retrieve ...
1
vote
2answers
123 views

Copying feature classes from Personal Geodatabase to File Geodatabase using ArcPy?

I have huge amount of personal geodatabases that contain dataset and feature classes (one dataset with four feature classes and one feature classes outside of the dataset in each mdb). I want to ...
3
votes
2answers
155 views

Managing size of personal geodatabase?

I am currently running processing on two feature classes (points, number of points are 5000+ and 8000+ respectively) in ArcGIS 10.2 on personal geodatabase using iteration and selection by ...
0
votes
1answer
168 views

How do you delete a feature class if ArcCatalog locks the geodatabase?

I'm trying to delete a feature class from a personal geodatabase using ArcCatalog but the file is locked because it's opened exclusively by me. The process fails to get a schema lock. Well of course ...
1
vote
1answer
183 views

ArcGIS 10.2: ArcPy - how to replace workspace paths?

I am teaching myself ArcPy and I am attempting to make a code to replace paths to the items in my workspace. I had a file geodatabase and its path changed so I would like to automatically modify the ...
0
votes
1answer
50 views

Preserve input attribute schema option NOT working when using Feature to Polygon in ArcGIS

I have successfully converted a polyline fc with 1,780 records into a polygon fc in ArcGIS 10.1, by using the tool: Feature To Polygon, but the output does not keep the attributes of the input fc (I ...
8
votes
0answers
254 views

Connecting Problem: ODBC versus ESRI Personal Geodatabase (*.mdb)

I try over 2 days to connect an ESRI Personal Geodatabase with QGIS 2.8.1 Here is my testing report. Testing environment: Windows 7 64-bit; MS Office 32-bit; QGIS 32-Bit 1. Step: Creating an ...
-1
votes
1answer
604 views

Connect to an ESRI Personal Geodatabase (*.mdb)

My environment: Windows 7 Professional: Service Pack 1 64-Bit QGIS: QGIS-Version: 2.8.2-Wien 32-Bit Microsoft Office 2010 Professional: 32-bit I want to connect an ESRI Personal Geodatabase ...
0
votes
1answer
70 views

.mdb is not a valid layer and can not be added to the map

I know this question has been asked quite a few times before but I couldn't find an answer that suited my situation at all. So this is what happens. Currently, I am using ArcGIS to map the sewer ...
0
votes
2answers
163 views

Copying Personal Geodatabase (in Access) with relationship classes to ArcSDE for SQL Server?

How to copy a Personal Geodatabase (in Access) with relationship classes to ArcSDE for SQL Server. I tried a simple copy paste and imported, but didn't get the relationship classes. error: unable ...
0
votes
1answer
91 views

Export geodatabase relationship to shapefile [duplicate]

I have a personal geodatabase with a polygon feature class with a one-to-many relationship to a table. What I want to do is to export to a shapefile with all the infornation associated in every ...
0
votes
0answers
66 views

Unable to save edits in ArcGIS after modification of personal gdb in Access

Hope someone has had experience with this before. We've exported a feature class from ArcGIS SDE database and saved it in a personal geodatabase. Then we altered the structure within Access 365, and ...
0
votes
0answers
77 views

QGIS 2.8.1 crashes when connecting to Personal Geodatabase?

I have a problem connecting to a ESRI Personal Geodatabase. I used to be able to connect to the database using QGIS 2.6.1, but I did some editing to the database in Arc and after that I was unable to ...
1
vote
0answers
150 views

Exporting data from ArcSDE gdb atribute table to file or personal geodatabase?

I'm currently learning GIS and I'm working on a project, I'm doing my own research and trying to accomplish the following with or without Python: Export data from an ArcSDE geodatabase attribute ...
0
votes
1answer
223 views

How can I convert ESRI personal geodatabase (.mdb) to shapefile using OGR in C#?

I have to create a class in C# in which I would like to insert a function that converts an ESRI personal geodatabase, extracting that features it contains in shp using OGR. I looked at library ...
2
votes
2answers
532 views

Enforcing unique values in field when editing in ArcMap?

I am working on a geodatabase. In some of my features, I would like to add a field, in which I will type the values on my own. On this field no duplicates must be allowed. In other words I want it to ...
0
votes
0answers
74 views

How to open MDB personal geodatabase in JAVA

I'm trying to open a MDB personal geodatabase using the ArcGISSDK java10.2.4 doing the following: String ...
2
votes
1answer
4k views

Opening Esri Personal Geodatabase (*.mdb) using QGIS 2.6?

Is it possible to open an Esri Personal Geodatabase (*.mdb; ArcGIS 10.2) in QGIS 2.6? Previous versions were right.
2
votes
1answer
126 views

Esri Geometric Network - Error Code 18 (unknown)

We have created a geometric network in a Personal Geodatabase with ArcGIS 10.2.2 for Desktop. Each time we are getting an error code of 18 on a particular point feature. As you can see here, there ...
-1
votes
2answers
121 views

File or personal database in qgis?

is there any database ? I use ArcMap with file geodatabase. But now, i have make project in qgis and i dont know, how to create database.
0
votes
0answers
25 views

How to …NonRelational geoDB to Relational geoDB

I have Access personal database without any relations and would like to import all data in SQL using ARCSDE Personal and build relations. This is bad structured database and I just couldn't figure out ...
2
votes
0answers
115 views

Open mdb database (created in ArcGIS10) in QGIS 2.2/2.4

I have a bunch of orthophotomaps (about 250 tiff files) organized in 3 mdb databases created in ArcGIS10. I'm now trying to open the mdb files one by one in Qgis 2.2 and 2.4 (Layer->Add vector ...
2
votes
3answers
2k views

Converting personal geodatabase .mdb file to .gdb

Is it possible to convert an MS Access personal geodatabase file to a SDE enterprise geodatabase file format? What kind of python scripting would it entail? I need to convert it in such way to ...
1
vote
0answers
100 views

Migrate MS Access Data into Oracle DB

I was sent some old MS Access files that contained survey data and served as a "file geodatabase". I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning. I ...
0
votes
1answer
238 views

How to add mdb geodatabase layer (feature class) to QGIS project using python?

I want to add a feature class of a personal geodatabase mdb to my qgs project by code (a plugin I am working on). I am using a command similar to that used for adding shapefiles, but this is not ...
0
votes
0answers
48 views

Finding What version a PGDB is programtically

So i have a list of 681 personal geodatabases. I want to figure out what version (9.x, 8.x, 10.x) these things are. So i want to write a program that will read the filepath from a database table and ...
1
vote
2answers
415 views

How to use an IF THEN statement in an sql Select expression?

I need to select the top 3 records from a table, but depending on an inline variable from an iteration, occasionally one of those top 3 records should not be selected and should be replaced by the top ...
1
vote
1answer
11 views

Generate Statistics from check-out GDB While performing Check-in

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. How to generate statistics of the edits performed on the check-out GDB, before check-in. for example: i want to have ...
1
vote
0answers
2k views

Failed to Connect to database: Underlying database error occured

I'm trying to connect to a personal database in ArcGIS 10.2 that contains work that I've spent the last two weeks working on but I am now receiving an error: Failed to connect to database. An ...
1
vote
1answer
564 views

Error 001156. increasing the length of text limit [duplicate]

I'm fairly new to ArcGIS for Desktop and i want to import my excel table to my personal gdb but i end up getting an error code:001156 and my import fails. I soon found out that it was the lengthy ...
1
vote
1answer
34 views

32bit to 64bit topology errors

Can generating a shapefile from a pgdb cause topology errors due to floating point conversion? I am running into gaps in a line layer of really small distances (order of 10^-4; CRS EPSG:2227 usft). ...
1
vote
0answers
94 views

Converting MDB File With Unicode Characters

I'm using C# wrapper of GDAL and I'm having a problem converting MDB file that contains unicode characters. Lets take for example conversion to KML file, non-English characters are replaced by '?' ...
2
votes
2answers
198 views

Writing data into Esri *.mdb personal geodatabase using QGIS?

I have an empty *.mdb database that I have to fill with data. The problem is that I cannot install ArcGIS for Desktop on Ubuntu, so I decided to do it using QGIS 2.0.1 with a Grass plugin. However, ...
1
vote
1answer
185 views

Join Attributes by Location: .mdb and shapefile in QGIS

I can join attributes by location in QGIS using 2 shapefiles. However, I do not know how to do the join when one of my files is in a .mdb format while the other is a shapefile.
2
votes
2answers
319 views

Create FeatureClass in Personal Geodatabase and store data

I have to create a new featureClass in my existing personal GeoDatabase. And save some polylines into this featureClass. How can i do it? I need c# code to do this. Edit: I have a problem during ...