A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

1
vote
1answer
24 views

Linking Mapinfo polygon to MS Access DBMS records?

Does anyone know of simple way or bit of code to link a MS ACCESS DBMS point to an associated polygon, so that spatial attributes of the polygon can be recorded into the DBMS fields. I am a user not ...
1
vote
1answer
34 views

Merging CAD and .mdb table into a feature class

I have cad file (.dwg) which contains the geometry and the attributes are in the tables of access (.mdb) database. The common FIELD in both of them is "HANDLE". How do I convert these into a ...
1
vote
1answer
132 views

Link Excel Table to Access/Arcmap Personal Geodatabase Table

My overall goal: My coworkers have an excel table which they update/use frequently. The table is not in a format that arcmap can decipher. Therefore, I've created a locked sheet (in the format I ...
1
vote
1answer
140 views

Unable to modify form in Access when linked to ArcGIS using a database connection

I created a split Access 2010 database with a back-end for just tables and the front end with queries and forms. The front-end is linked using an OLE DB connection to ArcGIS, which works fine. When ...
1
vote
1answer
142 views

FME Data Tranform and Concatenate Tables in DB without Key from Access to SQL

I have been able to do a conversion (in FME2013) from an Access DB to a SQL Express DB(in Desktop Workbench), adding some transformers to grab data from three of the tables, two of which have primary ...
0
votes
1answer
49 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, ...
2
votes
0answers
59 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
250 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
0answers
296 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 ...
2
votes
0answers
128 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
281 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 ...
2
votes
0answers
376 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
0answers
114 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 ...
2
votes
0answers
526 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 ...
1
vote
0answers
35 views

issues in table reading from MS Access using ODBC

I want to add two tables from my MS Access db. So I follow the procedure to add ODBC (add vector layer, database, etc.) and it works. I choose the tables that I want to add and hit ok. Qgis adds both ...
1
vote
0answers
23 views

Successfully importing URLs from Access to ArcMap

I have an access database (2013 .accdb) with a column containing URLs. This field uses the hyperlink data type in access. I made an OLE connection to the database in ArcMap 10.3.1 but the URLs come in ...
1
vote
0answers
58 views

ArcMap & Catalog: DB connection to ACCDB file

I have successfully established a database connection using ArcCatalog to an access database. I am using Access 2013 and ArcMap 10.2.2. I used as a database provider Microsoft Jet Engine version 12.0 ...
1
vote
0answers
88 views

Access 2000 database via ArcCatalog displays decimals as integers?

I import an Access 2000 database through ArcCatalog. When I complete the process and check the attribute table, the values come not as decimals as they are in the database but as integer numbers. Why ...
1
vote
0answers
175 views

Batch Zonal Statistics to Spreadsheets?

I have a pretty immense amount of Zonal Statistics as Table computations to do, and would love to find a way to grab mean and variance values from the little .dbf tables ArcGIS creates and put them ...
1
vote
0answers
748 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 ...
1
vote
0answers
633 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 ...
1
vote
0answers
125 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
225 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
0answers
21 views

Table Join in AutoCAD shapefile and MS access

I have a shapefile and an MS Access table with a common field. I want to join the shapefile to the table. Is this possible? If yes, how can I then add the MS Access table to AutoCAD?
0
votes
0answers
63 views

how to create geometry type(point,line,polygon)on esri personal geodatabase*.mdb?

Qgis can not read geometry type on ms access*.mdb's table connecting with esri personal geodatabase *.mdb? This can open as test file, but unknow geometry type. Point can create using with "point ...
0
votes
0answers
41 views

QGIS persistent connection to MS Access tables/queries

I am new to QGIS and currently on a steep learning curve. I need to access tables/queries in an MS Access database and have managed to do so via the eVis plugin. The problem I have is the fact that ...
0
votes
0answers
30 views

How To Get Results From Javascript / Google Maps API 3

First of all, I am desperate! My application that was working fine for years using Google Maps API 2 has failed. Evidently Google has stopped supporting it or changed something. My clients are not ...
0
votes
0answers
71 views

Multiple join of Access data with ArcGIS shapefile

I am looking for a solution for joining constantly modificated data to my shapefile. The shapefile consists of polygons. Each one has a code. In the Access database, I have varias colums for one code ...
0
votes
0answers
52 views

Small individual tables/crosstabs for points from Access to plot on maps

I currently have an Access database (accdb format) that is currently linked in GIS (ArcGIS 10.1) through an OLE DB connection. I have a groundwater analytical table with 36,000+ records that contains ...
0
votes
0answers
114 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
1k views

How to connect qgis with access database

I am new at this but I am tring to connect Access database with Qgis like I would in ArcView but iI get this problem. Hoping someone can help.
0
votes
0answers
277 views

PGeo: MDB Tools driver not found

I'm trying to load a Access .gdb(.mdb) database into postgis using ogr2ogr. I'm running Ubuntu 14.04 with gdal 1.10. I've install both unixODBC and mdbtools as per the instructions at http://www.gdal....
0
votes
0answers
2k 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?
0
votes
0answers
204 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
145 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.