A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

2
votes
0answers
293 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
615 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
262 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
8k 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
449 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
108 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
510 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
248 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 ...
1
vote
0answers
386 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
1k 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
554 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
320 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
483 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
482 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

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
289 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
154 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?
9
votes
5answers
8k 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
666 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
799 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
688 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 ...