A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

0
votes
0answers
19 views

Relationship between MS Access DB and Google Maps API/Fusion Tables

We are having an issue with a project that we are working on using Google API and M.S Access. Our project goal is to design a web map in Google API where we can select a parcel of land and have all of ...
0
votes
1answer
40 views

Connecting to PostGIS (LATIN1) from Microsoft Access 2010 - Encoding problem?

I want to connect to a PostGIS table Using MS Access. The table has been created using the PostGIS Shapefile loader in pgAdmin. It has been encoded at LATIN1 (it wouldn't load with UTF-8 default). I ...
1
vote
0answers
48 views

Arc GIS 10.2 Relating Tables in an OLE DB

I have a large registry of about 260,000 records in microsoft access with data on land quarter sections. This data was to much for Arc GIS to handle directly, so I created a Microsoft Jet 4.0 OLE DB ...
0
votes
1answer
80 views

Create Ms-Access type queries in ArcMap [closed]

We have a dataset with a personal GDB (mdb) with several feature classes and an mxd tied to those features to create layers based on definition queries… Currently to QAQC our data we use MsAccess ...
1
vote
1answer
130 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 ...
1
vote
0answers
44 views

Automate data entry into Access from ArcMap

I have an Access 2007-2010 database that I'm currently working on by manually searching for roads in a defined set of areas in ArcMap 10.1 and then filling in the area's ID in an empty column in the ...
1
vote
0answers
40 views

Querying and summarizing/reporting a multiple tables database

I have to create a database with information on Scottish buildings from 17 and 18 centuries. In order for my data to be searchable I need to have a series of tables connected with 1 to many ...
0
votes
1answer
19 views

How to make XY to Line dynamic to access query?

I have connected the Access file to the ArcGIS file, and displayed it using the tool XY to line, but when I change the access file, this is not automatically adjusted in the ArcGIS template. Somehow, ...
1
vote
1answer
18 views

Is it possible to add a gvSIG document on Html?And if yes, how?

I have completed a project in gvSIG and now I would like to be able to open it from my webpage, like a hyperlink or path or something.Can I really do that somehow? And if yes, could you please explain ...
0
votes
0answers
22 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 ...
0
votes
0answers
116 views

Extract ESRI geodatabase data with QGIS [duplicate]

Is it possible for QGIS to extract data from an ESRI personal geodatabase (.mdb)?
1
vote
2answers
129 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 up ...
2
votes
2answers
239 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 ...
4
votes
2answers
139 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 ...
1
vote
1answer
90 views

Can SQLite and SpatialLite files be linked

Coming from a ms-access background, it is common to split up larger applications into several database files. An ms-access database can then access data that is in another database via a linked ...
3
votes
1answer
123 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 ...
2
votes
0answers
124 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 ...
1
vote
1answer
114 views

Hyperlinking Access db to ArcMap

I am trying to hyperlink from MS Access to ArcMap to view specific features. Within MS Access, I have 1400+ lines catalogued. I would like to click a button and view the line in ArcMap. Any ideas ...
3
votes
2answers
558 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 ...
0
votes
0answers
133 views

MS Access join table values, not recognized by ArcGIS symbology

I joined a MS Access database table to a GIS file. When I try to use symbology (categories) to represent a yes/no value which is in the table file (0/-1) it does not recognize it as a value.
0
votes
0answers
86 views

How to Export a Geodatabase with Subtypes and Domains to Microsoft Access Without Losing Information?

I want to export a geodatabase file with all subtypes and domains values to open in Microsoft Access without losing any information.
2
votes
0answers
91 views

Connecting Access Table to ArcGIS (Replace Function!)

I have an Access Query where the Field names contain symbols like "-", ":" and spaces. When I was connecting my database to ArcCatalogue that specific Query-table was not visible. Then I used Replace ...
2
votes
0answers
194 views

Generate QGIS maps automatic after updating an Access 2010 or Filemaker Pro 12 database

I want to develop a database which consist an interaction with QGIS. After updating the data in the database I want to push on a button and start a process in QGIS. After finishing the process in QGIS ...
3
votes
2answers
434 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
168 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 ...
8
votes
3answers
707 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 ...
2
votes
1answer
36 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 ...
4
votes
3answers
3k 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 ...
0
votes
1answer
636 views

arcpy - how to run geoprocessing python script on SDE

I was testing my script on a .gdb on my local drive and I got it to work. The actual geodatabase I would like to run the script on is an SDE. I tried changing my filepath from the .gdb to the .sde and ...
7
votes
1answer
96 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 ...
2
votes
1answer
682 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 ...
1
vote
1answer
546 views

How to export 1.5 million records from File Geodatabase to Microsoft Access table

I have a table that I want to export from arcmap that has around 1.5 million records. I need to import it into access. Now every time I have tried to export it into a format that access will read, ...
12
votes
2answers
489 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 ...
8
votes
2answers
1k 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 ...
5
votes
5answers
4k 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 ...
3
votes
2answers
424 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 ...
5
votes
1answer
1k 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 ...
4
votes
3answers
5k views

How to import info from mdb file?

I need to import info on a QGIS project. The info are in a MDB file (population, mean age, number cars and so on per Town) that is possible to connect with a region shape from an ID (the ID is the ...
2
votes
0answers
261 views

Parcel ID Mapping (brainstorming)

In my project I have a table full of residential properties by Parcel_ID. Table 2 is a TIGER streets shapefile. I would like to build a query in MS Access displaying all properties within a mile ...
2
votes
3answers
527 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
220 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 ...
4
votes
2answers
5k 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 ...
0
votes
3answers
377 views

How can I query and categorize a shapefile using MS Access?

Is there a way to categorize locations by lat-long in MS Access using caparisons to shapefiles?
2
votes
0answers
102 views

How to use Domain Codes set in a Feature Class when opening the Feature Class in MS Access

If I set domain codes on a feature class, does this translate into MS Access as well? For example, I set a domain code and use it on a field in the feature class, I can then go into ArcMap, start an ...
3
votes
2answers
449 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 ...
2
votes
1answer
224 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 ...
0
votes
0answers
347 views

Open the IGxDialog in MS Access 2010 using VBA

I hope this is the right forum for this question. I have a program in MS Access that allows users to input varius aspects related to land treatments including the spatial information (point, line, or ...
2
votes
1answer
480 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. ...
1
vote
1answer
287 views

ArcMap - ODBC connection to SDE table shows an old version?

I use an ODBC connection to an SDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL SDE server and the connection info matches what I ...
2
votes
2answers
451 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 ...