A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

1
vote
1answer
23 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
179 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
78 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
56 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
302 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
528 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
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 ...
1
vote
1answer
68 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
91 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
1answer
103 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 ...
1
vote
0answers
130 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
561 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
185 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
390 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
83 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
133 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 ...
1
vote
0answers
448 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 ...
0
votes
3answers
564 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
52 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
88 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
99 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
195 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
37 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
22 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
25 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
8 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
16 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
34 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
15 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 ...
0
votes
0answers
90 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
1answer
64 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
0answers
136 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
43 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
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
40 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
186 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
129 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
178 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 ...