A desktop database software package from Microsoft
1
vote
1answer
53 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
222 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
72 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
56 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.
0
votes
0answers
178 views
Linking an MS Access OLE Object to a KML with VBA
I have a VBA script that creates a blank KML and writes to it, pulling from query fields to populate the description/pop-up bubble, and the place marks (from a coordinates field in the Access DB).
...
2
votes
0answers
58 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
116 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
235 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
117 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
1answer
349 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
29 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 ...
3
votes
3answers
849 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
315 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
76 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
282 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
255 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
350 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
579 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
4answers
2k 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
360 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
692 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 ...
2
votes
0answers
200 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
399 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
157 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
1k 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
267 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
88 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
327 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
164 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
285 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
319 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
221 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
327 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
364 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
829 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.
...
6
votes
2answers
1k views
Convert an ESRI File GDB Table to Access 2007 ACCDB table programmatically
Does anyone know of a method to convert an ESRI File Geodatabase Table into Access 2007 Table programmatically. I have been trying using the PYODBC library and a series of insert statements but am ...
4
votes
3answers
225 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
138 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?
8
votes
3answers
3k 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 ...
2
votes
1answer
531 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
565 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?
6
votes
2answers
482 views
Allow multiple users to share personal geodatabases safely?
We're using ArcGIS 9.3 but for reasons beyond the scope of this question we have to stick with personal geodatabases (MS Access .mdb's) and multiple users. How can we set this up so only a limited few ...
