A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

2
votes
0answers
123 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
274 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
371 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
501 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
1answer
87 views

Getting around current database field limitations?

I have a need to store over 350 fields in a table and have this information readily available to display spatially. The problem is that access only allows for 255 fields. So the feature class that I ...
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, ...
1
vote
1answer
170 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 ...
1
vote
1answer
432 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 ...
1
vote
1answer
28 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 ...
1
vote
1answer
222 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 ...
1
vote
1answer
130 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. ...
1
vote
1answer
165 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 ...
1
vote
1answer
97 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 ...
1
vote
1answer
454 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
1answer
286 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
1answer
28 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
86 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
0answers
84 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
1answer
117 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
133 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 ...
1
vote
0answers
166 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
708 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
592 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
113 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
205 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
3answers
668 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?
0
votes
1answer
91 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
1answer
120 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
219 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 ...
0
votes
1answer
264 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 ...
0
votes
1answer
50 views

How to list tables in MS Access database using MapBasic?

My task is read data from *.mdb files using Mapbasic. Code to open MS Access database is seen in help immediately: Register Table source_file Type ACCESS Table table_name where source_file is ...
0
votes
1answer
115 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 ...
0
votes
1answer
47 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
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 ...
0
votes
0answers
52 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
2answers
70 views

How to bulk load Picture Marker Symbols into .style for ArcMap

I have close to 1000 PNG files that I want to make Picture Marker Symbols stored in a .style file. I am very familiar with Microsoft Access, Python and ArcGIS and I know some C# and .NET. When I ...
0
votes
0answers
58 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 ...
0
votes
0answers
48 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
13 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
47 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
79 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
774 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
236 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 ...
0
votes
1answer
51 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. ...
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
1answer
46 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, ...
0
votes
0answers
203 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
141 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.
-1
votes
1answer
362 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 ...