A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

4
votes
2answers
849 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
924 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
265 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
212 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
419 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
276 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
617 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
163 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
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 ...
0
votes
0answers
198 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
139 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
119 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
265 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
621 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
263 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
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 ...
2
votes
1answer
42 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 ...
5
votes
3answers
7k 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
1k 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
103 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 ...
3
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 ...
1
vote
1answer
1k views

Exporting 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, ...
15
votes
2answers
900 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 ...
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 ...
6
votes
6answers
10k 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
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 ...
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
13k 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 ...
2
votes
0answers
364 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
782 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
334 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 ...
5
votes
2answers
17k 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
645 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
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 ...
3
votes
2answers
636 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
327 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
0answers
486 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 ...
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 ...
2
votes
1answer
730 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
419 views

ODBC connection to ArcSDE table shows old version in ArcMap?

I use an ODBC connection to an ArcSDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL ArcSDE server and the connection info matches ...
2
votes
2answers
545 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 ...
3
votes
1answer
571 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
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. ...
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 ...
4
votes
3answers
340 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 ...
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?
10
votes
5answers
13k 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 ...
3
votes
1answer
858 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 ...
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?