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

learn more… | top users | synonyms (1)

1
vote
1answer
22 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
35 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
40 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
57 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
54 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
145 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
60 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
60 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
24 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 ...
4
votes
0answers
102 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
180 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
47 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
126 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
63 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
37 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
59 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
102 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
127 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
249 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
54 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
2k 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
77 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
104 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
24 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
89 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
997 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
68 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
159 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
37 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
198 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
10 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
1k 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
247 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
32 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
83 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
160 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
139 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
1answer
207 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 ...
2
votes
1answer
567 views

Query to select MIN and MAX values by groups

In ArcMap 10 i'm working in a Personal Geodatabase where the points (see screenshot below) represent the number of each house in the street. Each point has an ObjectID. This ObjectID is an unique ...
0
votes
0answers
1k views

How to access a .mdb file (Microsoft Access) in Qgis (with windows 7)?

I've a very big problem. I need to connect shapes from a polygon layer with a .mdb file (built by Microsoft Access) in Qgis 1.8 (with windows 7), but I can't access it. Can anyone give me some help?
2
votes
3answers
3k views

How to auto increment a field in a feature class?

So I'm relatively new to ArcGIS and ArcCatalog. I have created a field name of PROJECTID in a feature class in a Personal Geodatabase. The data type is TEXT. This will be a ten digit ID. The first ...
1
vote
1answer
105 views

How to get replaceDataSource to work with personal geodatabase?

I am having trouble using the arcpy.mapping's replaceDataSource with a personal geodatabase. The script runs, but does nothing if I run the script in the python window of ArcMap. If I run it in ...
0
votes
0answers
65 views

Personal Geodatabase not recognized when connecting to folder

I am trying to connect to a personal geodatabase I created in Catalog. When I navigate to the location of the geodatabase, it isn't displayed. It seems to not be recognized. Any ideas?
-2
votes
1answer
558 views

ArcGIS Python Add in: Pass Entry from Combo Box (in Toolbar) to mdb [duplicate]

How do you update the python addin wizard code to write directly into access or pgdb? I have a combo box and need to have my users enter data into the combobox to write into the database. Can someone ...
1
vote
5answers
502 views

Alternative backup File or Personal Geodatabase

I'm wondering if there is a way around or an alternative way to backup a File or Personal Geodatabase. For example: If I have a very large dataset within the File or Personal Geodatabase and I want ...
0
votes
0answers
48 views

The topology cannot be validated because it is checked out

when I try to validate an existing topologiy in my personal GDB I got this error "the topology cannot be validated because it is checked out". How to solve it? thanks! It is a personal GDB. I'm ...
0
votes
1answer
189 views

Do Personal Geodatabases show up when trying to Export Data using ArcGIS 10.1 SP 1 (on Windows 7)?

I work with ArcGIS 10.1 SP 1 (on Windows 7), and I tried to export a feature layer to a personnal geodatabase using "right click in the table of content > data > export data". However, when I select ...
2
votes
2answers
263 views

Trouble Copying Data into File Geodatabase from Personal Geodatabase

I've been unable to successfully copy and paste personal geodatabase feature classes to a new file geodatabase in ArcCatalog 10.1. As the screenshot shows, the Data Transfer dialog box contains all ...
1
vote
3answers
2k views

How to Convert a Number to Percentage in Field Calculator

Using ArcGIS 10.2 and Personal geodatabase,I have a field with values of Numbers like 0.461538 and Type of "Double" can you please let me know how I can Export them to new Field in Percentage Format ...
2
votes
0answers
518 views

import esri Personal Geodatabase (.mdb) to PostGIS

I would like to import an esri Personal Geodatabase (.mdb) to PostGIS. I have tried to follow the blog post: How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux I installed the GDAL ...