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.
155 questions
1
vote
1
answer
416
views
Joining Access tables to ArcGIS layers
I'm attempting to Join an Access query/table from an .accdb to a layer in ArcGIS Pro 3.0.
I've made an OLE DB connection to the Access database, and made a query to get the table in access able to be ...
1
vote
1
answer
637
views
Moving database from ArcGIS Online Feature Layer to Microsoft Access
I have a project that involves collecting data in Survey123 (hosted as a ArcGIS Online Feature Layer) and conducting QA/QC in Microsoft Access. We're trying to come up with the best process for moving ...
- 13
0
votes
0
answers
683
views
Access database in Pro
I am trying to work in Pro on an mxd that was started by a previous employee, and it opens, but the data path on the access database files is all wonky, and the file doesn't show in Pro.
I attempted ...
1
vote
1
answer
313
views
Reading a MapInfo TAB File with .accdb (Microsoft Access)
I have a MapInfo TAB consisting of 5 files: .tab, .map, .id, .aid, .accdb
The attributes seem to be stored in the .accdb Microsoft Access database file.
Using GDAL 3.5.0 on Windows 10 installed via ...
- 12.4k
0
votes
0
answers
66
views
There's any way to export data from Access to polygons without having UniqueIDs?
I have polygons. I would need to have more information on them. I have that information in an Access database. But I don't have any identifier to serve as a reference. When I do a CSV import, it doesn'...
- 13
0
votes
1
answer
74
views
Can't update row in Microsoft Access
I am trying to fill an empty column with unique number for every data, I use the following code:
import arcpy
my_input = []
column = "REGION_ID"
column1 = "MUNICIPAL_ID"
column2 = &...
- 3
0
votes
1
answer
1k
views
Convert MS Access .mdb database files to alternative formats for work under Linux?
For a long time, I am struggling with .mdb databases I receive for my work under Linux (especially with QGIS). Even from within Access on Windows, I found no convenient way to export the whole ...
- 3,269
0
votes
1
answer
160
views
Access MDB connection file result does not have an object ID in ArcGIS 10.8
I have made an MDB Access Connection by linking the Excel file with the Access one, but when I looked at the result in ArcMap the feature class table does not have an Object ID on it. I tried to ...
0
votes
0
answers
68
views
Georeference vertical images on 3D wireframe
I would like to make a 3D wireframe model of a room in a building and then georeference images of the walls on the wireframe. Once I have the images rendering on the walls I want to insert points on ...
- 1
2
votes
1
answer
2k
views
Add tables from access database to QGIS
There are some similar question here, but nothing worked for me. So I have a database that has the ending .mdb which to my knowledge is some kind of Microsoft access database. But I also tried it with ...
- 1,459
1
vote
0
answers
35
views
Strange QGIS plugin behaviour if it runs for the first time
I have made a plugin that works fine in itself. Shortly said it fills a combobox based on a MS Access table. Then features in the map are shown that meet the value I select in the combobox.
But I ...
- 137
0
votes
3
answers
278
views
Processing raster present as MS Access database
I wanted to know if anyone has experience working with WISE soil database, I am trying to process world soil data which is downloaded from here
https://data.isric.org/geonetwork/srv/eng/catalog....
- 239
0
votes
0
answers
415
views
Linking or joining data in MS Acess to shapefiles in QGIS
I am creating a spatial database for five buildings for a project that I am working on. I have spatial data in the form of a shapefile and attribute data in Microsoft Access(with a table and queries). ...
- 115
0
votes
0
answers
452
views
Import PostgreSQL into MS Access OBDC Error While Exectuing the Query #7
Trying to import a table from PostgreSQL to MS Access (2007) however, I keep getting the error
OBDC Call Failed - Error While Executing the Query #7
STEPS TAKEN
In OBDC Data Source Admin (32-bit), ...
- 1
0
votes
1
answer
376
views
How to open .dbf table exported from ArcMap 10.7 with Access 2013 or later Microsoft Office versions? [closed]
I have exported an attribute table as .dbf file with ArcMap 10.7 but if I try to link it to an Access 2013 database (it works fine with Access 2007) I get a message error "Could not find installable ...
- 33