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
0
votes
1answer
32 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 ...
0
votes
2answers
62 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 ...
1
vote
1answer
56 views

QGIS interfacing with Microsoft Access

I know that it is possible to link databases from Access to QGIS via the ODBC Data Source administrator. I am curious if it would be possible to create a python code/plugin that would allow the ...
8
votes
1answer
4k views

How does Personal Geodatabase work from Microsoft Access perspective? [closed]

I am trying to get a better general understanding of how ArcGIS works with MS Access when using a personal geodatabase. If I create a new pgdb and then import a very simple shapefile and finally look ...
1
vote
1answer
83 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
2answers
1k 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 ...
1
vote
1answer
469 views

Connecting to PostGIS (LATIN1) from Microsoft Access 2010 with Encoding

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 ...
0
votes
3answers
53 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 ...
1
vote
1answer
21 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 ...
1
vote
0answers
1k views

Creating relationship between MS Access DB and Google Maps API/Fusion Tables? [closed]

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 ...
3
votes
0answers
87 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
82 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
70 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 ...
16
votes
5answers
24k views

Reading ODBC connection using QGIS? [closed]

I have a co-worker who manages a large MS Access database that contains X & Y fields for various locations he tracks. We have previously exported the data to CSV and used the QGIS Delimited Text ...
1
vote
1answer
90 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
15 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
0answers
63 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 ...
6
votes
3answers
40k views

How to embed a map into Access Database?

I am developing a database for my organisation that could be spatially enabled. I have to use MS Access 2007 on Windows and am therefore looking for any possibilities to incorporate my Access ...
-1
votes
1answer
171 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
0answers
29 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
77 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
240 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
460 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 ...
0
votes
1answer
154 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 ...
-2
votes
1answer
58 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 > ...
6
votes
3answers
27k views

Import info from mdb file into a project?

I need to import info on a QGIS project. The info are in a MDB file (population, mean age, number of cars and so on: one record per region) that is written to be connected with a region shape from an ...
1
vote
1answer
211 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
2answers
227 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 ...
2
votes
1answer
392 views

Umlaute not displayed correctly when loading .mdb MS Access into QGIS (1.9.0-Master) with eVis

I am loading an .mdb (MS Access 97 or 2003) to QGIS (1.9) via the eVis database conection. Connecting to the mdb, selecting a table and displaying it as a point-layer through the appropriate x/y-...
1
vote
0answers
55 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(...
3
votes
2answers
2k 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 ...
2
votes
0answers
483 views

Parcel ID Mapping (brainstorming) [closed]

In my project I have a table full of residential properties by Parcel_ID. Table 2 is a TIGER streets shapefile. I would like to build a query in MS Access displaying all properties within a mile ...
-1
votes
1answer
115 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 ...
0
votes
1answer
77 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, ...
2
votes
0answers
190 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
214 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")...
5
votes
2answers
730 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
2answers
208 views

Hyperlinking Access db to ArcMap

I am trying to hyperlink from MS Access to ArcMap to view specific features. Within MS Access, I have 1400+ lines catalogued. I would like to click a button and view the line in ArcMap. Any ideas ...
2
votes
1answer
536 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
378 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
1answer
185 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 ...
6
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 ...
1
vote
0answers
315 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 ...
0
votes
1answer
5k views

How to connect QGIS with Access database [duplicate]

I am trying to connect Access database with QGIS like I would in ArcView but I get this problem. Data source name not found and no default driver specified QODBC3: Unable to connect Hoping someone ...
1
vote
1answer
398 views

Bulk loading 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
0answers
262 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
366 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
182 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 >...