A desktop database software package from Microsoft

learn more… | top users | synonyms (1)

0
votes
0answers
11 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
21 views

Processing or accessing .mdb linestring column (wkt)?

On my ms access .mdb table, linestring (WKT) column are called from add vector layer selected database with odbc connection link. It is Successful but can't directly access lines. Can i convert ...
-3
votes
0answers
6 views

processing or directly accessing to .mdb linestring column(wkt) [duplicate]

On my ms access .mdb table, linestring (WKT)column are called from add vector layer selected database with odbc connection link. It is Successful. But can't directly access to lines.Can i convert ...
0
votes
0answers
29 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
50 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
27 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
52 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
55 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
54 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
180 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 ...
6
votes
8answers
12k 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 ...
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
0answers
66 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
1answer
72 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
33 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 ...
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. ...
3
votes
2answers
655 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
101 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
119 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 ...
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.
1
vote
1answer
305 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 ...
5
votes
2answers
229 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 ...
-2
votes
2answers
192 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 (....
2
votes
0answers
126 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 ...
4
votes
1answer
139 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 ...
5
votes
1answer
294 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 ...
0
votes
2answers
82 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 ...
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 ...
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 ...
1
vote
1answer
150 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
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, ...
0
votes
0answers
63 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
50 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 ...
4
votes
2answers
1k 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 ...
2
votes
1answer
286 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 ...
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 ...
9
votes
2answers
3k 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 ...
3
votes
1answer
464 views

How to Export Datalayer to Access 2010?

I'm working with ArcGIS v10.1 and MS Access 2010. Can you export a datalayer directly into Access 2010 (.accdb)? This was possible under using older versions of ArcGIS with Access 2003. I created a ...
0
votes
1answer
95 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 ...
3
votes
1answer
707 views

Editing 2007 MS Access *.accdb using OLE DB connection?

Can you edit a 2007 MS Access .accdb file format using the OLE DB connection? I have made the connection using the following: Connecting to a 2007 Microsoft Access database (.accdb) in ArcGIS I can ...
1
vote
1answer
443 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 ...
8
votes
2answers
2k views

Converting File Geodatabase Table to Access 2007 ACCDB table programmatically?

Does anyone know of a method to convert a File Geodatabase Table into an Access 2007 Table programmatically. I have been trying using the PYODBC library and a series of insert statements but am ...
0
votes
0answers
98 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
103 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
204 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
239 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
775 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 ...
-1
votes
1answer
385 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 ...
0
votes
0answers
969 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
136 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 ...