The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [ms-access]

A desktop relational database management system from Microsoft. To be used specifically with MS Access and related issues with SQL, macros or VBA in the software.

Filter by
Sorted by
Tagged with
1
vote
1answer
20 views

Displaying MS Access records as lines in ArcMap?

I'm trying to add an MS Access table as a layer in ArcMap 10.6. There are four columns with coordinates - from_x, from_y, to_x and to_y. I want to represent the records as lines on the map. I can add ...
0
votes
2answers
42 views

How to access/manipulate a feature class/dataset in a personal database by using cursor via ArcPy?

I wrote an ArcPy script which uses cursors and it works fine with shapefiles. However, it does not work if I execute the same thing in a personal geodatabase. Should I use different format for a ...
0
votes
1answer
40 views

Refreshing QGIS after updating MS Access database?

Why is QGIS not refreshing after updating a connected database? It is a MS Access Database which I connected to QGIS using ODBC. The database contains coordinates of some vessels and they are ...
3
votes
0answers
78 views

Refreshing QGIS project after updating MS Access Database?

I already connected the MS Access DB to QGIS via ODBC. Moreover, I applied the tool "create point layer from table" and I got all points from the DB (longitude/latitude coordinates) on my map. And ...
0
votes
0answers
29 views

Connecting QGIS 3.4 to a MS Access database

I try to connect to MS Access and i have already created an ODBC connection. Now, I have the the problem that I cannot open the database in QGIS (but the connection was succesful).
2
votes
1answer
52 views

Displaying dynamic text in Data Driven Pages from joined MS Access database table?

I'm running ArcMap 10.4 and trying to incorporate text from a joined MS Access 2013 table (through an OLE DB connection) as a dynamic text element in a data driven pages setup. Adding dynamic text ...
0
votes
0answers
14 views

PDF print from Access with picture

I have a problem with PDF print in Access. I have a data base with more than 10 Fields, one of the fields is the address to the picture. Every record have own picture.When I want to print all records ...
1
vote
1answer
50 views

Connect to a SQL Server database from MS Access [closed]

I have an existing Microsoft SQL Server database which has been configured as an Enterprise geodatabase. I want to access it in MS Access in order to extract data to populate a form. What is the ...
0
votes
0answers
40 views

Import tables from MSAccess to QGIS

I'm running QGIS 3.4.2 on Windows 7 64bit. I need to import periodically a specific table from several different MS-Access 2010 mdb's. The database and path changes quite often, so an odbc solution is ...
1
vote
0answers
27 views

Query an MS Access geodatabase for specific field shape data in ArcMap

I'm trying to help my wife with something in ArcMap. She works with ArcMap/ArcGIS every day but has no programming or database knowledge beyond creating basic tables, queries and forms in Access. I, ...
0
votes
1answer
51 views

Access Databases and connecting to ArGIS Online

Does anyone have any experience using ARGIS Online/Portal and connecting a MS Access database to visually represent spatially referenced data. I have a database that is regularly updated, can I ...
2
votes
1answer
211 views

Create a point shapefile from table in .accdb database

I am a beginner in Python. I have a database in .accdb format of Access 2007. The database has a table called "T_point_RT" which has point data. I want to create a point shapefile from North and Est ...
0
votes
1answer
356 views

Is it possible to edit a layer from Esri Personal Geodatabase in QGIS 3? [duplicate]

After a lot of research and effort I have successfully made a connection to my Esri Personal Geodatabase (.mdb file). Now I want to edit some attribute data in the attribute table of a layer... BUT I ...
-2
votes
1answer
52 views

ArcGIS query not working in Personal Geodatabase when OK with shapefile?

I have one strange problem. I have access database that fills at daily bases. I import it to arcgis and data displays normaly but I want to filter data by date. I write query like this : date_field > ...
0
votes
1answer
115 views

What could cause text under 255 characters to import as BLOB format?

I'm importing a table from an .accdb file in Access 2016 into ArcMap 10.6 via an OLE DB connection and one of my nine text fields is importing in BLOB format. It and all the other fields are formatted ...
1
vote
2answers
169 views

.mdb file and MinGX, MinGY, MaxGx, MaxGY parameters

I have .mdb file ( Microsoft Access file ) which appears to be a shapefile index ( snapshot as attached ) and i need to get longitude and latitude from this so that file can be fed to Tableau or ...
1
vote
0answers
40 views

Unable to connect to data source attendance “ODBC:attendance” [closed]

I'm having an issue connecting to my MS Access DB (.md file) under the ODBC USER DSN configuration in Windows. Setting up my DSN configuration under the System DSN failed, rather USER DSN works(...
-1
votes
1answer
100 views

How can I combine multiple personal geodatabase with same format in Access file? [closed]

I have multiple geodatabases with the same format in features and attribute tables, their difference is thier location, how I can combine them in one file in Access format which has one attribute ...
-1
votes
1answer
151 views

In ArcMap my Definition Query is removing all records but categorizing on symbology works properly

I have a definition query to filter an attribute in a feature class, the Attribute is joined to the dataset being queried from an Access MDB and is data type SHORT, the values it contains are 1,0, &...
1
vote
1answer
72 views

Linking data from Microsoft access to ArcMap 10.1

I'm trying to link data in a Microsoft Access file to my work in ArcMap 10.1. Instructions online show people using the 'Customize' menu option and then selecting 'ArcCatalog' and from there ...
2
votes
0answers
180 views

arcpy connect to accdb with 64bit background processing

I'm trying to read from a accdb MS Access Database via python in a ArcGIS Toolbox tool. I already established a database connection (via Add OLE DB in ArcCatalog) which I can use in a 32bit python ...
1
vote
1answer
191 views

MS Access/VBA used to open an ArcGIS map document: Map fails to connect to database

I have an MS Access front-end that can be used to open ArcGIS map documents (.mxds). It has a macro that runs an OpenRoadMap() function: Function OpenRoadMap() CreateObject("Shell.Application")...
2
votes
1answer
445 views

Why can't I create a feature class in ArcCatalog when using a .MDB file?

I am trying to use an access database with geographic information in ArcCatalog. I created the database as a .accdb and backsaved to a .mdb format. I can create a 'shapefile', but not a 'File and ...
1
vote
1answer
153 views

Importing data from MS Access?

I'm trying to import data from MS Access but unsuccessful. The commands tab (Customize> customize mode> commands) doesn't show "ArcCatalog", so I'm stuck here being failed to add "Add OLE DB ...
5
votes
0answers
3k views

Connecting QGIS to ODBC database (MS Access *.accdb) [closed]

Has anybody managed to successfully connect to open a MS Access *.accdb database from QGIS using ODBC? All the Q&A, tutorials, guides and videos I've found work with *.mdb files and ESRI ...
3
votes
2answers
1k views

How to get data from Access to QGIS?

Currently there is the following software in use: Win10 Clients, MS Access, ArcView 3.2 from year 1999 There are 3 common workflows, I describe one: Within the MS Access Form a Dataset is selected ...
1
vote
0answers
263 views

Using Access Hyperlink Field Type in ArcGIS

I've been searching for an answer to my particular issue, but haven't turned up any answers after a couple days of searching. I am using Access 2013 and ArcInfo 10.X My issue is: I have an Access ...
1
vote
1answer
342 views

Dynamic updating of Events Layers created from XY Data in ArcGIS Desktop?

Are Events layers created from displaying XY Data in a table, updated dynamically when the table is updated? I have an Access db table that I am dumping data into, and I created an Events layer from ...
1
vote
0answers
230 views

Creating a domain based off specific attribute selection or lookup table in ArcGIS/Access?

Is it possible to have a domain on a database in ArcGIS that creates a drop down pick list on an attribute then have the next field have a domain based on that section? For example: Field A - choose ...
1
vote
0answers
308 views

Adding Microsoft Access Table to ArcMap?

I am looking to map gps coordinates from a Microsoft Access table (.mdb) in ArcMap. I successfully connected ArcMap to Microsoft Access through an OLE DB connection, and can see the Access table in ...
1
vote
0answers
35 views

Linking Access Database with arcgis 10 and is it more efficient?

I have currently started working for a fisheries consultancy. They have all their data eg. catch rates, fishing effort, gear types in an Access database. Existing and previous projects have map/mxd ...
1
vote
0answers
170 views

Table to Excel creating sheet name with special characters 10.3

I have been searching through forums to solve this issue with no luck. I work for a housing finance agency specializing in affordable housing. When we receive applications, we send letters to ...
2
votes
0answers
2k views

Access database file to QGIS [duplicate]

I'm trying to import an Access file (.mdb) to QuantumGIS. This database comes from a geodatabase from ArcGIS. Can someone explain me how to do it? I tried to import from Add Vector Layer > Database >...
1
vote
1answer
636 views

Why non-geodatabase MS Access tables should not be added directly to ArcMap?

I would like to join table from .mdb to the attribute table of feature class to perform some data manipulation, however on the join validation I get a warning: Non-geodatabase MS Access tables ...
0
votes
2answers
563 views

Embed Esri map in MS Access Report or Form

I have forms and reports in an MS Access front-end that reference tables in an Oracle ESRI.ST_GEOMETRY back end. The forms allow users to tabularly navigate through construction project attributes in ...
1
vote
0answers
275 views

Adding “monitor” layer with Access Database and coordinates x/y in QGIS?

I want to add a Microsoft Access "mdb" or "accdb" as vector layer. The layer should work all the time with current updated data from the Access file. This function allready exist for a txt(!) file: ...
1
vote
0answers
54 views

What to do with unused layers in my personal geodatabase

I have a question about my personal geodatabase. You can see it at the picture below. I started with the database in Arcmap with my normal data (Black sea, Danube, East Aegean and West Aegean). In ...
2
votes
1answer
99 views

Adding editable Excel (or Access) table in ArcMap?

I have flood data from the past ten years written in an Excel table. Now I would like to connect the table to ArcMap, so I can join it with the shapefiles. Normally this isn't that hard, but because ...
4
votes
0answers
665 views

Open .mdb files in QGIS 2.14.1

I Use QGIS ver 2.14.1 I've got a little problem here I already following how to open mdb at link below : QGIS 2.4 access .mdb add error But error dialog box always pop out when I click "OK" (after ...
3
votes
1answer
604 views

Linking ArcGIS to Access

I am working to link spatial data in ArcGIS 10.3.1 (parcels with many attributes) to an Access database of customers. Initially all I need is to identify which parcels are in my database and append ...
1
vote
1answer
118 views

Adding join to table from Microsoft Access in ModelBuilder gives ERROR 999999?

I am working on a model in ArcMap (10.4.1) that calculates habitat suitability over a series of timesteps. The data needed to calculate habitat suitability at each timestep is stored in a specific ...
5
votes
2answers
617 views

Using SSURGO data without MS Access?

I'm building a GIS for a large-scale family farm. We don't have a lot of resources to devote to this, as it's a new part of the farming operation and therefore viewed with some reserved skepticism. ...
1
vote
1answer
214 views

How can I connect a Microsoft Access Database and a FGDB, such that information put into the former is automatically transferred to the latter?

I am working on a project for the National Park Service. The goal of the project is to connect a Microsoft Access Database to a File Geodatabase, where any information put into the .accdb tables will ...
0
votes
1answer
211 views

Using ogr2ogr to Export from Access to CSV (or Oracle)

I received a an Access database too many observations to simply export as a CSV by either the export buttons in Access or copying and pasting. I tried using ogr2ogr and only get the headers in my "...
1
vote
0answers
104 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
63 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 ...
1
vote
1answer
160 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 ...
1
vote
0answers
475 views

ArcMap & Catalog: DB connection to ACCDB file [closed]

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 ...
-2
votes
1answer
941 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
2k 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 ...