Tagged Questions

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

learn more… | top users | synonyms (1)

0
votes
0answers
15 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
43 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
6 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
73 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
13 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
27 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). ...
0
votes
0answers
23 views

Data migration through ETL Tool from file to personal geodatabase with existing geometric network and cardinality rule?

I want to perform data migration through ETL tool from file geodatabase to personal geodatabase with existing geometric network and cardinality rule. Please describe how to migrate?
1
vote
0answers
40 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
85 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
69 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.
0
votes
1answer
104 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
104 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
181 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
558 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
61 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
48 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
331 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
271 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
39 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
100 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
165 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
577 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
306 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 ...
0
votes
0answers
287 views

Arcgis 10.2 - Table was not found error in a personal geodatabase

I'm working with a geometric network within a personal geodatabase. I've imported a feature class the was topologically fixed from one PGDB to another. Than created a geometric network with weights. ...
2
votes
3answers
487 views

How to acquire schema lock is one already exists?

I'm trying to delete a feature class from a feature dataset or to add a field to it, but I keep getting an error message (pics attached below). I have imported a geometric network I've created from ...
0
votes
0answers
28 views

Why does MAPublisher need to install Office 2010 redistributable x64 version to connect to Personal Geodatabase (MS Access)?

I am trying to connect to a personal geodatabase. a .mdb file, with MAPublisher but I get the message immediately to install a Office 2010 redistributable x64 version. I have installed 64 bit office ...
7
votes
4answers
2k views

How do I open personal geodatabase in QGIS 2.0?

Good afternoon. I am trying to use an ArcGIS (10.2) personal database MDB as a container for data to pass to a QGIS user. I formerly used QGIS 1.8 for Mac OSX, and after some fiddling around, I was ...
1
vote
0answers
147 views

Personal Geodatabase not recognized as valid datasource in the last QGIS Windows Weekly build (64 bits)

I was using Personal Geodatabases in QGIS without any problem but it's stopped to work since I installed the last 64 bits weekly build for Windows (1.9.0-35-Setup-x86_64). I'm now receiving an ...
2
votes
1answer
57 views

Can I make an ESRI checkout replica from a checkout replica?

If I create a checkout from a clients geodatabase, can I then turn around and put that replica on our ArcGIS Server and create a couple replicas from it? So, then, our replicas would be synced to the ...
2
votes
1answer
92 views

Load PGDB with filename

this is my first question here and I have done extensive searches but still can't find the (full?) answer I'm looking for. Hopefully someone can help! I am loading a number of personal geodatabases ...
0
votes
0answers
185 views

Export From PGDB to ArcSde Using C#

I need help exporting a personal geodatabase Feature Class to an ArcSDE geodatabase using C# ArcObjects with ArcGIS 9.3. I just want to replicate the tool Feature Class to Feature Class ...
1
vote
1answer
140 views

Access Personal geodatabase using java

Following example through ESRI is to access the features of file geodatabase (GDB) , ...
31
votes
7answers
9k views

Whether to use File Geodatabase (*.gdb), Personal Geodatabase (*.mdb) or shapefiles?

I am a bit confused on the topic of geodatabases. Previously, I have used geodatabases as an easy way to keep all files together rather than having dozens of shapefiles all over the place. And it's ...
6
votes
1answer
182 views

How much database bloat is reasonable?

I use personal geodatabases to hold all the data for my projects (probably around 10-20 feature classes across 2-4 datasets on average). I use the personal gdb because I like being able to hook into ...
1
vote
1answer
151 views

Check Personal Geodatabase attribute against external MySQL database?

I have a Personal Geodatabase to which editors enter values from some field inputs. I would like some of the entries, eg Project No ( whose name is unique and has some some related attributes like ...
1
vote
0answers
932 views

Cannot Import Feature Class into Personal Geodatabase in ArcGIS 10.1

My objective is really simple. I have a shapefile and would like to convert it to a Feature Class. My goal is to use HEM tools, which I think requires me to convert my shapefile of interest to a ...
1
vote
0answers
83 views

Copying Features from One ArcMap window to another, without losing Related Tables

In our current workflow we are working in a Personal Geodatabase with few features and related tables , many persons will be working in different schemes. When we need to merge these schemes\Pgdb to ...
6
votes
2answers
529 views

How to Export a Personal Geodatabase to ArcSDE

I want to copy/export my personal geodatabase which consists of feature datasets, relationship class etc to an Enterprise geodatabase. What would be the best approach?
5
votes
2answers
446 views

Read an ArcGIS Feature dataset using GDAL

I am new to GDAL in Python and would like to use it to create a list of populated layers in a ArcGIS mdb Feature datasets. I have the code below that provides a list of all the populated layers but ...
2
votes
2answers
196 views

Driver Error : DTM to Raster using GDAL_GRID

I am looking to interpolate a DTM (eventually over 4,000 DTMs) that is in a personal geodatabase format. I would like to do this in as few step as possible, eventually writing a batch script to do ...
3
votes
0answers
64 views

Rasterization tools for vector datasets with styles

I have hundreds of Personal Geodatabases and I want to create one georeferenced TIFF for each one. Each PGDB has the same feature classes ('CotourLines', 'Hidrography', etc) for what I have some ...
2
votes
1answer
78 views

Latitude and Longitudes are replaced with zeros when importing excel 2007 worksheet into personal geodatabase

I am trying to import an Excel 2007 data set into a personal geodatabase so I can convert coordinate systems. The data set includes point locations in Decimal Degrees. When I import the Excel ...
3
votes
2answers
482 views

Why does ArcMap connect to a Personal Geodatabase (PGDB) even when no feature classes (or tables?) are referenced in the MXD?

I have an odd question from a user in the same goverment that I work for. When he opens a .MXD-project in ArcMAP a Personal Geodatabase also opens that is not part of the project and does not have ...
6
votes
2answers
2k views

Is there a way to create a Personal Geodatabase in QGIS?

I believe I know the answer, but I wanted to ask. Is there a way to create a Personal Geodatabase in QGIS? I know QGIS can view Personal Geodatabases, but can one be created? I have a project where ...
10
votes
3answers
1k views

Can ESRI Personal Geodatabase be viewed with any software other than ArcGIS?

Is it possible to open a PGDB file in software other than ArcGIS? i.e are there any opensource software available just for viewing the data?
2
votes
1answer
47 views

When Zooming Personal Geodatabase Feature Class Error came

When i joined two different feature class attribute table while i have to zooming the PGDB feature class , drawing error will come. I have attached an example image to show the problem. Thanks to ...
5
votes
1answer
2k views

how does a personal-gdb work from a MS Access perspective?

I am trying to get a better general understanding of how ArcGIS works with MS Access when using a personal geodatabase. If I create a new pgdb and then import a very simple shapefile and finally look ...
3
votes
1answer
172 views

Append feature layer from one personal geodatabase to another using .Net

I currently have a client that still uses personal geodatabases (Access files). I currently have to open up ArcCatalog and manually append any FeatureLayers that are contained in the original personal ...
2
votes
2answers
249 views

Problem with Coordinate Tolerances when I export my .shp files to .mdb

When I export my shapefile to a personal geodatabase using ArcMap, the result is not the same as the original database. I do not know how to solve this problem.
11
votes
3answers
968 views

Are personal geodatabases better suited for quickly querying indexed attributes than file geodatabases?

I'm preparing data for an ArcEngine application that queries the data to search for an address. Sometimes we search just on the street name field, just on the house number field, or both. When using ...