A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

0
votes
0answers
11 views

Expecting ArcCatalog category under command section in customize mode? [on hold]

I need to open an access file in arcmap, so i wanted to add OLE DB command button. but although, i open ArcCatalog first, there's no ArcCatalog category under command section in customize mode. what ...
1
vote
0answers
33 views

issues in table reading from MS Access using ODBC

I want to add two tables from my MS Access db. So I follow the procedure to add ODBC (add vector layer, database, etc.) and it works. I choose the tables that I want to add and hit ok. Qgis adds both ...
1
vote
0answers
21 views

Successfully importing URLs from Access to ArcMap

I have an access database (2013 .accdb) with a column containing URLs. This field uses the hyperlink data type in access. I made an OLE connection to the database in ArcMap 10.3.1 but the URLs come in ...
0
votes
0answers
21 views

Table Join in AutoCAD shapefile and MS access

I have a shapefile and an MS Access table with a common field. I want to join the shapefile to the table. Is this possible? If yes, how can I then add the MS Access table to AutoCAD?
0
votes
0answers
62 views

how to create geometry type(point,line,polygon)on esri personal geodatabase*.mdb?

Qgis can not read geometry type on ms access*.mdb's table connecting with esri personal geodatabase *.mdb? This can open as test file, but unknow geometry type. Point can create using with "point ...
1
vote
1answer
24 views

Linking Mapinfo polygon to MS Access DBMS records?

Does anyone know of simple way or bit of code to link a MS ACCESS DBMS point to an associated polygon, so that spatial attributes of the polygon can be recorded into the DBMS fields. I am a user not ...
0
votes
0answers
40 views

QGIS persistent connection to MS Access tables/queries

I am new to QGIS and currently on a steep learning curve. I need to access tables/queries in an MS Access database and have managed to do so via the eVis plugin. The problem I have is the fact that ...
1
vote
0answers
57 views

ArcMap & Catalog: DB connection to ACCDB file

I have successfully established a database connection using ArcCatalog to an access database. I am using Access 2013 and ArcMap 10.2.2. I used as a database provider Microsoft Jet Engine version 12.0 ...
0
votes
0answers
30 views

How To Get Results From Javascript / Google Maps API 3

First of all, I am desperate! My application that was working fine for years using Google Maps API 2 has failed. Evidently Google has stopped supporting it or changed something. My clients are not ...
-2
votes
1answer
62 views

Linking an ArcGIS map to an access database

How do you connect and ArcGIS map to a Microsoft Access Database? The database has data on monitoring wells (i.e. water levels, chemical concentrations...ect) and the ArcGIS Map has well locations. ...
0
votes
1answer
72 views

Linking a Google Map to MS Access

So I have been doing a lot of research on this topic but I am new to working with online mapping. I have an access database and I would like to portray information in a google map. I have learned how ...
2
votes
0answers
59 views

Load an (updating) point layer from Access: Problems with pointslayerfromtable algorithm

I'm a python dummy user and in general a QGIS dummy user. I'm using 32 bit QGIS 2.14.1 Essen version. Referred to the post How to load an (updating) point layer from Access? ,i try underdark solution ...
1
vote
1answer
90 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 ...
0
votes
1answer
75 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 ...
1
vote
1answer
34 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 ...
2
votes
1answer
114 views

Transfer data from access mdb to personal geodatabase (OLE, Python scripting)

I am very new in Python. And I guess I need to use lots of Python here. I have MS Access 2003-2007 database (mdb format) and personal geodatabase (mdb). I created a tool in Access that imports data ...
1
vote
1answer
128 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 ...
-2
votes
2answers
225 views

How to connect to Geomedia data in Acess .mdb from ArcGIS Desktop [closed]

I can't connect to an Access database from a GIS platform. I tried ArcGIS 10.1 and QGIS but I did not succeed. I specify that this Access database was used in GeoMedia and export it to access (....
5
votes
2answers
266 views

Remote connection to PostGIS?

I have recently setup PostgreSQL and PostGIS on a debian server on a local network in my home, which is working perfectly. I am able to access the db from other machines on the same network using the ...
0
votes
0answers
70 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 ...
5
votes
1answer
304 views

Using Python to discriminate Personal Geodatabases and MS Access Databases

I need to list a server's geodatabases, to analyze and process them. My users are however creating both personal geodatabases and MS Access geodatabases. Listing mdb files reports both types of ...
4
votes
1answer
152 views

Converting Python script for QGIS?

I am still a novice in python, but I have the long term goal to create a plugin one day. The first step to this plugin is a test with QGIS python scripts to convert an Access mdb into sqlite db and ...
2
votes
1answer
50 views

Does it matter whether I use ArcCatalog or Access to compact a geodatabase?

I've been tasked with compacting some of the personal geodatabases (MDB files) in our office every few weeks. These reside on a couple of separate file servers. I have been using ArcCatalog to do ...
0
votes
2answers
90 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 ...
1
vote
1answer
164 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
188 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 ...
0
votes
0answers
52 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 ...
1
vote
0answers
88 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 ...
4
votes
2answers
2k views

Connecting QGIS to query on MS Access database?

Is there a method to connect to an MS Access database file (.mdb) using QGIS? In particular I need to connect to a query in it. The database does not have spatial data.
2
votes
1answer
304 views

Is it possible to import a KMZ file in to access with VBA?

I am building an MS Access database and am a beginner but have experience with VBA coding in excel (including the generation of KML files). In theory, is it possible to import a KMZ file in to ...
0
votes
0answers
111 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 ...
1
vote
1answer
106 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 ...
2
votes
1answer
224 views

ArcCatalog not in Customize mode

I need to connect to an Access Databse so have found the instructions to Add OLE DB Connection but when I go to Customize - Customize Mode there is no option to select ArcCatalog under Commands. Can ...
2
votes
0answers
250 views

MS Access to Google Earth Pro

I am embarking on a new project and hoping for some pointers. I am reasonably tech savvy but definitely in the "advanced beginner" category for coding... but keen to test myself. I am trying to find ...
3
votes
2answers
858 views

GeoDatabase to KML Conversion

I have some US Forest Service GIS data which is a set of roads and trails an Accesss Database, also commonly referred to a GeoDatabase or a Personal GeoDatabase. Its a standard Access MDB File. From a ...
0
votes
1answer
98 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
0answers
1k 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.
1
vote
1answer
139 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 ...
0
votes
1answer
124 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 ...
1
vote
1answer
142 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 ...
0
votes
0answers
277 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 http://www.gdal....
-1
votes
1answer
400 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 ...
6
votes
1answer
4k views

QGIS 2.4 access .mdb add error

So I followed the instruction here: Can QGIS read an ODBC connection? for adding a .mdb into QGIS. There are great instructions about 1/3 of the way down. But I still can't get it to open. I on ...
2
votes
1answer
175 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 ...
0
votes
1answer
126 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 (http://www....
0
votes
1answer
49 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
54 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. ...
1
vote
1answer
496 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
0answers
175 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 ...
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?