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
0answers
22 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
41 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
33 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
41 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
183 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
274 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
47 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
84 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
149 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
38 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
92 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
135 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
68 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
170 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
179 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
368 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
134 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 ...
4
votes
0answers
2k 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
234 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
313 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
195 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
280 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
33 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
160 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
574 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
529 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
260 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
51 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
97 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
646 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
532 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
112 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
555 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
196 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
206 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
102 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
61 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
147 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
447 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
871 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 ...
2
votes
0answers
126 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
99 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
395 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
82 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
744 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 ...