A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

15
votes
2answers
991 views

Need a spatial database that can be used by QGIS and R

I'm quite new to QGIS and I'm searching for a simple way to create a Database that allows me to use the tables in QGIS and R. I have a lot of data stored in Excel spreadsheets wich will be used for ...
10
votes
5answers
15k views

Can QGIS read an ODBC connection?

I have a co-worker who manages a large MS Access database that contains X & Y fields for various locations he tracks. We have previously exported the data to CSV and used the QGIS Delimited Text ...
9
votes
2answers
3k views

Converting ms-access database into easy to use spatial database

I've recently come into ownership of an MS-Access database (2007 accdb), which I want to be able to use in a GIS. I know a little bit about GIS (I've used QGIS and ArcGIS quite a bit) but very little ...
8
votes
3answers
2k views

How to fix “Unable to initialize ODBC connection to DSN for ALC_AV_CO”?

So I am new to the QGIS community, and I have been trying to bring in some rather large access databases with little to no success. I have windows 7, so I've gone in through administrative tools/Data ...
8
votes
2answers
2k views

Converting File Geodatabase Table to Access 2007 ACCDB table programmatically?

Does anyone know of a method to convert a File Geodatabase Table into an Access 2007 Table programmatically. I have been trying using the PYODBC library and a series of insert statements but am ...
7
votes
1answer
108 views

Is it possible to add an ArcMap map to a report in Access?

I am using Access to create printable maps where I can change parameters (border colors) on the fly... Currently, I am exporting the maps to JPEG then pulling them in. I would like to import MXD ...
7
votes
1answer
2k views

Add layer to open mxd using ArcObjects from outside the map document crashes ArcMap

I have an Access database (MS Access 2010) that allows users to enter a variety of land treatment information including associated points, lines, or polygons which users can select and the database ...
6
votes
1answer
4k views

QGIS 2.4 access .mdb add error

So I followed the instruction here: Can QGIS read an ODBC connection? for adding a .mdb into QGIS. There are great instructions about 1/3 of the way down. But I still can't get it to open. I on ...
6
votes
8answers
12k views

Why can't I export XY data to a shapefile?

I have added a table from Access to ArcMap, and then used 'Display XY data' to plot points. When I then try to export the Events to a shapefile I get an error message telling me: "Error exporting ...
6
votes
1answer
3k views

How does Personal Geodatabase work from Microsoft 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 ...
5
votes
3answers
8k views

Is there a way to link ArcGIS to MS Access and use that DB?

I have an IT background but I am new to GIS. I recently recieved training using ARCMAP. I have about 5000 farmers that I need to put in a database and access the information using GIS. The vision is ...
5
votes
3answers
14k views

How to import info from mdb file into a project?

I need to import info on a QGIS project. The info are in a MDB file (population, mean age, number of cars and so on: one record per region) that is written to be connected with a region shape from an ...
5
votes
1answer
294 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 ...
5
votes
2answers
229 views

Remote connection to PostGIS?

I have recently setup PostgreSQL and PostGIS on a debian server on a local network in my home, which is working perfectly. I am able to access the db from other machines on the same network using the ...
5
votes
2answers
20k views

How to embed map into access database?

I am developing a database for my organisation that could be spatially enabled. I have to use MS Access 2007 on Windows and am therefore looking for any possibilities to encorporate my access DB into ...
4
votes
3answers
354 views

How to import an Access database to GeoDjango?

I'm a I've just inherited a pile of institutional geodata that's stored in an MS Access database. I need to pull that data out into a format that I can work with in GeoDjango--so I'm OK with ...
4
votes
2answers
2k views

Connecting QGIS to query on MS Access database?

Is there a method to connect to an MS Access database file (.mdb) using QGIS? In particular I need to connect to a query in it. The database does not have spatial data.
4
votes
1answer
139 views

Converting Python script for QGIS?

I am still a novice in python, but I have the long term goal to create a plugin one day. The first step to this plugin is a test with QGIS python scripts to convert an Access mdb into sqlite db and ...
4
votes
2answers
1k views

MS Access and geocoding in ArcGIS

We are a small non-profit. We use a fairly complex MS Access application to track everything. We would very much like to geocode addresses in our application and display the results on a map. In ...
4
votes
1answer
1k views

How can I use a variable to specify which field to update with arcpy.UpdateCursor?

I am writing a script that cycles through several different point shapefiles, finds how many lie within a given area and the writes the outcome to a table in an Access database. I've used an search ...
4
votes
2answers
282 views

can Well Known Text tables be used effectively, stored in Access or Base?

My question is: How do I import WKT text data back into QGIS, and how useful could Base or Access be in storing the data using WKT rather than spatially enabling it within a proper GIS database, like ...
4
votes
2answers
962 views

QGIS 64-bit ODBC set up link to 32-bit Access on win7

I am trying to set up a an ODBC link to Access 2007 32-bit but not having any success. My system is a win7 pro 64-bit and I have QGIS 64-bit installed. Here are the steps I have already tried. Set ...
3
votes
2answers
1k views

Using ArcObjects, how to convert an Access table into a proper geodatabase table?

I have inherited an ArcGIS application that creates a number of access database tables. I'd like to use ArcObjects to convert them to proper geodatabase tables, which I understand to mean simply ...
3
votes
1answer
707 views

Editing 2007 MS Access *.accdb using OLE DB connection?

Can you edit a 2007 MS Access .accdb file format using the OLE DB connection? I have made the connection using the following: Connecting to a 2007 Microsoft Access database (.accdb) in ArcGIS I can ...
3
votes
2answers
655 views

Zoom to Polygon in Arcmap from Access

I am attempting to Zoom from an Access record to a specific polygon in ArcMAP but I can't seem to get the function to work. The field in Access is identical to the field in arcmap. I.E. they both ...
3
votes
2answers
774 views

GeoDatabase to KML Conversion

I have some US Forest Service GIS data which is a set of roads and trails an Accesss Database, also commonly referred to a GeoDatabase or a Personal GeoDatabase. Its a standard Access MDB File. From a ...
3
votes
2answers
1k views

ArcGIS 10 MapControls in MS Access, can it be done?

In the past (9.3 ArcGIS) I was able to develop forms in MS Access where I could drop a MapControl on and have GIS functionality all within Access as long as ArcMap was installed on the same machine. ...
3
votes
1answer
899 views

MapInfo 10.5.1 Update and MS Access Database

I am having problems with a database that I have developed. The data uses MapInfo for any of the spatial parts of it. I installed the update to MapInfo 10.5.1 and I now get an error when I am trying ...
3
votes
2answers
1k views

Display Access query in ArcMap

Hi I have an access database and have some built in queries in the database. The same data is stored in geodatabase with the spatial information. Now I want to follow this process: Access->push out ...
3
votes
1answer
587 views

Spatial Database Connection String

From MS Access, I'd like to create a link to the attribute table of an SDE feature class in a spatial database. For example, I have the following connection string which works for an OLE DB ...
3
votes
1answer
464 views

How to Export Datalayer to Access 2010?

I'm working with ArcGIS v10.1 and MS Access 2010. Can you export a datalayer directly into Access 2010 (.accdb)? This was possible under using older versions of ArcGIS with Access 2003. I created a ...
3
votes
2answers
643 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 ...
3
votes
1answer
276 views

Geoserver Link to External MS-Access Database

Is there a way that I can link a shape (as a polygon, with a LINK_ID = 12345) from Geoserver and have it open or link to the specific information (LINK_ID_DB = 12345) within an online Web Microsoft ...
3
votes
1answer
159 views

Can the Reporting Tool in ArcMap connect to Auxiliary data, like Excel tables?

Is it possible in ArcMap 10, using the reporting tool, to connect a report to non-spatial data, like from Excel or Access tables?
2
votes
4answers
1k views

What's long binary data?

I'm trying to turn data in a Microsoft Access file into an ArcGIS-10 layer. The table contains a column labeled "shape." Each line in this column reads "long binary data." What's that?
2
votes
1answer
756 views

Getting number of tables loaded with integrated mapping

I am integrating a MapInfo map into a form in an Access database. I am trying to find out the number of tables loaded but NumTables() and MapperInfo() are both getting "unrecognized command" errors. ...
2
votes
1answer
50 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
3answers
824 views

Connecting to non geodatabase MS Access database using ArcObjects

I am trying to connect to an MS Access database from a program I have written in VB.Net with ArcObjects 10.0. My MS Access database is not a personal geodatabase so apparently I have to connect to ...
2
votes
2answers
559 views

Understanding How ArcGIS Displays Non Spatial Data Created in Microsoft Access

I am working on getting American Community Survey(ACS) data into SDE table format. I have managed to import all the text files downloaded from ACS into excel and then imported to Access for further ...
2
votes
1answer
286 views

Is it possible to import a KMZ file in to access with VBA?

I am building an MS Access database and am a beginner but have experience with VBA coding in excel (including the generation of KML files). In theory, is it possible to import a KMZ file in to ...
2
votes
1answer
204 views

ArcCatalog not in Customize mode

I need to connect to an Access Databse so have found the instructions to Add OLE DB Connection but when I go to Customize - Customize Mode there is no option to select ArcCatalog under Commands. Can ...
2
votes
2answers
351 views

Mapping Tables for Parcel IDs

I am working on a residential real estate database in MS ACCESS. I currently have residential property’s tagged by parcel ID’s. I am trying to run a query to pull in multiple sales data from various ...
2
votes
1answer
347 views

Embedding slippy map in Access form

I have an access database which holds several sites. This is linked to a MapInfo TAB file which holds geometry for each site. I would like for our non-GIS users to be able to view the sites in an ...
2
votes
1answer
101 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 ...
2
votes
1answer
814 views

Microsoft Access mdb “is not a valid or recognized data source” in QGIS

The answer to RyanDalton's question "Can QGIS read an ODBC connection?" explains how to establish a link in QGIS with an MS-Access table. Following his steps, I can establish an ODBC link (I ...
2
votes
1answer
43 views

Change Which FeatureClass a RelationshipClass Points at

When you use ArcGIS' Project tool it creates a new featureclass. This is awesome, unless the featureclass you projected had been related to twenty-some tables. All of those relationships still point ...
2
votes
0answers
54 views

Load an (updating) point layer from Access: Problems with pointslayerfromtable algorithm

I'm a python dummy user and in general a QGIS dummy user. I'm using 32 bit QGIS 2.14.1 Essen version. Referred to the post How to load an (updating) point layer from Access? ,i try underdark solution ...
2
votes
0answers
239 views

MS Access to Google Earth Pro

I am embarking on a new project and hoping for some pointers. I am reasonably tech savvy but definitely in the "advanced beginner" category for coding... but keen to test myself. I am trying to find ...
2
votes
1answer
171 views

Populating Access (*.mdb) table with text from Text Elements to inventory MXDs using ArcPy/Python?

I am trying to write a piece of code to populate an Access mdb table with information from text elements in an mxd (text elements all have "names"). The purpose of this is to create a catalog of my ...
2
votes
0answers
294 views

Umlaute not displayed correctly when loading .mdb MS Access into QGIS (1.9.0-Master) with eVis

Good evening, I am loading an .mdb (MS Access 97 or 2003) to QGIS (1.9) via the eVis database conection. Connecting to the mdb, selecting a table and displaying it as a point-layer through the ...