A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

0
votes
0answers
27 views

Can I merge an Access database with a shapefile into a file geodatabase? [on hold]

I'm working on a project where I'm trying to merge location information from points placed in a shapefile with information that I've entered into an Access database. There is a unique identifier with ...
1
vote
1answer
39 views

Is it possible to connect to an Access db via ModelBuilder?

I created an OLE DB Connection in ArcCatalog Database Connections. If I right click on one of my db tables I can "Create a Feature Class > From XY Table" and continue with my data processing. ...
0
votes
0answers
27 views

I need to link to or copy MS Access macros from a “master” database to MS Access personal geodatabase

Here's my situation: I'm a python and arcpy novice. I’ve been cannibalizing and modifying code from different sources into a work in progress. Development is in ArcGIS 10.1 and will need backwards ...
1
vote
1answer
83 views

How to load an (updating) point layer from Access?

I have a database table linked to the QGIS project which contains X,Y & Z coordinate information, which I can display in the Map View window of the project, after having used the “Points Layer ...
0
votes
0answers
28 views

Displaying Seasonal Weekly Monitoring Data in ArcGIS 10.2.2 from an MS Access Database

I have a MS Access relational database. I'm working with weekly trap catches from 468 Traps. This is long term monitoring data that was collected from 1 Sept (Start of Season) - 31 Aug (End of the ...
0
votes
0answers
9 views

Cannot Load Object - Region object type is not supported in this table. Operation canceled

I have linked an Access Database with MapInfo and created a mappable tab. However I am unable to populate the table with any regions/polygons/poly lines etc. It says "Cannot Load Object - Region ...
0
votes
0answers
23 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 ...
1
vote
0answers
75 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 ...
2
votes
1answer
150 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.
2
votes
1answer
108 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 ...
0
votes
0answers
37 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 ...
1
vote
1answer
66 views

Export to .dbf and .mdb

A have a number of shapefiles and I want to export their attribute table to .dbf and .mdb (Microsoft Access file). How can I do this with ArcGis or with any other tools? Notice that I want to keep ...
2
votes
1answer
56 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 ...
0
votes
0answers
16 views

Pivot/Cross-tab from MS Access to PostgreSQL

I have read a lot about crosstab and so on and how to create them in PostegrSQL, but I can't really figure it out how to adapt this (from MS Access): TRANSFORM Sum(L007_tot_Lega.Ton2013) AS ...
2
votes
0answers
85 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 ...
3
votes
2answers
132 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 ...
0
votes
1answer
54 views

Secure ArcGIS connections to Access .accdb?

With ArcGIS is it possible to secure connections to an Access 2007+ format database tables? At Connecting to a 2007 Microsoft Access database (.accdb) in ArcGIS it says "if the database has a ...
0
votes
0answers
127 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.
1
vote
1answer
71 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 ...
0
votes
1answer
69 views

Importing Excel file to ArcMap

https://www.dropbox.com/s/disaisc1wrv1mbi/Form470_2015-02-11-13-10-13.xls?dl=0 I downloaded that from the USAC (people that manage USF, E-Rate, etc.) web site. I've tried many combinations of ...
1
vote
1answer
94 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
0answers
143 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 ...
-1
votes
1answer
197 views

MS Access Database and ArcGIS

I would like to create an MS Database which is updated in real time with tabular data. The data should be processed automatically so that farmers are able to log in into the database and see charts ...
5
votes
1answer
2k 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 ...
1
vote
1answer
109 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 ...
0
votes
1answer
91 views

Problems Joining CSV to Shpfile arcgis 9.3

So I have been trying to get this to work all day and have had no success. I am attempting to join a CSV file with a Shapefile. The CSV is from the Hud's location affordability portal ...
0
votes
1answer
40 views

Online Interactive Directory [closed]

I have the following project and I'm figuring out how to best implement it. I would like the project to be as highly automated as possible. The suggestion was made that I make and access table, link ...
0
votes
1answer
44 views

Parts needed to run Geoserver/PostGIS from a program like Microsoft Access

I have a fair bit of experience in GIS and Python, but am brand new to developing on the web. I have rented some space on a server and have a PostgreSQL/PostGIS database as well as Geoserver on it. ...
1
vote
1answer
318 views

Merging Personal Geodatabase (MDB) data into ArcSDE using FME?

Im a novice in FME and I have a MDB file that i want to write/insert to an SDE database using FME. I created a simple translation that generally reads the data from the MDB file and writes it to the ...
1
vote
0answers
138 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 ...
0
votes
0answers
1k 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
1answer
102 views

Creating a New Shapefile from Joined Access Table

I'm dealing with a very large amount of polygons. Once I join the land use access table to the parcel shapefile, it takes forever for Arc to draw the polygons. I'm trying to select all residential ...
1
vote
0answers
579 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
1answer
193 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
411 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
202 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
561 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
88 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
137 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
41 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
24 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 ...
3
votes
2answers
707 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
742 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
235 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
187 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
350 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
257 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 ...
3
votes
1answer
493 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 ...
1
vote
1answer
155 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 ...
4
votes
2answers
914 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 ...