Hot answers tagged

7

Check it with odbc and search if database contain table starting with GDB_ import pyodbc db_file = "C:/path/to/my/database/MyDataBase.mdb" user = '' password = '' odbc_conn_str = 'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=%s;UID=%s;PWD=%s' % \ (db_file, user, password) cnxn = pyodbc.connect(odbc_conn_str) cursor = cnxn.cursor() if ...


6

Personal geodatabases--really anything with Access--have a ton of limitations. File geodatabases permit up to 65,534 fields per table/feature class. It should be no problem to import your existing data to a file geodatabase and then make the changes/additions that you need.


6

It's possible to connect via ODBC. In windows, start the ODBC Administrator and define your Datasource (Microsoft Access Driver). In QGIS go to Layer/Add Layer/Vector Layer/database: Type=ODBC. Set up a new Connection. Host should be "localhost" if your database is local on your machine. Database Name is the same name you defined before in the ODBC ...


4

Postgres configuration By default the Postgres server is only accessible from the same computer it runs on. You need to setup the Postgres server to listen not just locally, but on your internet facing network card too. This is done in the postgresql.conf configuration file. You will also need to enable user authentication from the outside, which is done ...


3

This should work: ##Database=group ##Access.mdb to SqLite=name ##inputmdb= input file ##outputsqlite = output file import sys, subprocess, os, sqlite3 as sql mdb_name = inputmdb sql_name = outputsqlite try: print "\nopening db" conn = sql.connect(sql_name) curs = conn.cursor() print "\ncreating schema" cmds = ...


3

No, the assumption was not correct (ArcObjects is calling the Access function, so there should be no difference). However: Access-based geodatabases are "old school", with limitations in size and capability; their use has been greatly de-emphasized of late, especially in light of the deprecation of PGDB support on 64-bit platforms (no ArcGIS Server or ...


2

Short awnser: you need to use dynamic DNS on your home router. I use DtDNS because they offer five free hostnames. you need to forward 5432 port on your router to your local debian server.


2

Given that VBA is a programming language, in theory, it is possible to process a KMZ file. However, you must first unzip it from binary into KML format. Maybe look at how-to-parse-process-a-kmz-file and Read From Binary Files in Visual Basic for inspiration. Then you need to parse this hierarchically structured KML data and reconcile it with the relationally ...


2

... or directly with MS Access Forms ... There is a sipmple way: You are able to define a action for each Layer (see: Layerproperties) There you can input a pythonscript. from win32com.client import Dispatch dbname ="dbname.mdb" dbForm = "frmname" filter ='id= "[% "ID" %]"' a=Dispatch("Access.Application") a.Visible=True objDB = a.CurrentDb() if ...


1

You need to access the system tables in MS Access to get a list of the available tables/views. This has been discussed earlier on stackoverflow You might be able to get to the entire context of the system table using this MapBasic statement: Register Table "C:\my access database.mbd" Type ACCESS Table "MSysObjects" Once you have the table open in ...


1

You are almost there. You have completed up to step 5, however arcpy.AddJoin_management just joins the two tables in memory (as per your manual step 5) - you'll still need to calculate the fields you want updated. For step six you'll want to make use of arcpy.CalculateField_management for each field you need to have updated, just as you would if you used ...


1

Like ArcGIS, GeoMedia uses the Access .mdb file for one of it's own proprietary data storage formats. The only thing in common between Esri's personal-gdb and Geomedia's .mdb is the extension. GDAL/OGR 1.9+ has a read-only driver for the Geomedia MDB database. You should be able to use ogr2ogr utility to convert the contents into data usable by both ArcGIS ...


1

Is there a way to link ArcGIS to MS Access and use that DB? addresses how to connect to an Access Database. One thing that is important to note, is that there needs to be a spatial component in your database in order for it to open in ArcGIS, but it will also need to be in a format readable by ArcMap. If you've ever opened the back end of a geodatabase, ...


1

I have faced the same problem, you can solve it by one of the following: Check the name of the table which you are joining with (In my case, I renamed it from Arabic to English, then the problem solved). Check the name of the fields within the table (no spaces, no symbols.. etc) Check the permission to the destination folder/drive you are exporting to.


1

Below is the model that will connect to an Access 2010 database table and create a point layer from the data. You need to create a Table View and feed that into the Make XY Event Layer tool. This is an in memory layer which can be used in processing but if you want to create a permanent version you need to save it, copy features will do this. When you ...


1

One option would be to add a small macro to the project properties which executes "points layer from table" automatically. For the styling, you can, for example, load a premade qml file. import processing def openProject(): pts = ...



Only top voted, non community-wiki answers of a minimum length are eligible