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

learn more… | top users | synonyms (1)

0
votes
1answer
21 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
91 views

copy personal access geodatabase with realtionship classes to arcsde sql

how to copy personal access geodatabase with realtionship classes to arcsde sql.used simple copy paste and import ,but didn't get the relationship classes.error:unable to initialize weights in feeder ...
0
votes
1answer
36 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
25 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
33 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 ...
0
votes
0answers
66 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
90 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
100 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
42 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
718 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.
1
vote
0answers
59 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
89 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
23 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
66 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
587 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
50 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
107 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
31 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
101 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
7 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
121 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
30 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
47 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
66 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
133 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
114 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.
1
vote
1answer
168 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
417 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
923 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
2k 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
89 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
61 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
520 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
430 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
43 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
170 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
243 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
1k 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
461 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 ...
2
votes
3answers
850 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 ...
7
votes
4answers
3k 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
198 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
78 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
99 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
237 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
172 views

Access Personal geodatabase using java

Following example through ESRI is to access the features of file geodatabase (GDB) , ...
35
votes
7answers
14k 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
247 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
173 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 ...