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.


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 = subprocess.Popen(["mdb-...


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 Pro)...


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

... 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

Open Catalog. Go to Customize>Toolbars>Customize and search "Add OLE DB Connection". Drag this tool to a toolbar. Click on the icon for the tool. Select Microsoft OLE DB Provider for ODBC Drivers and hit Next. Select "Use Connection String" and hit Build then select Machine source and double click MS Access Datasource then hit the Database button and browse ...


1

1) install QGIS http://www.qgis.org/en/site/ 2) export your access database to a csv 3) import csv to QGIS http://www.qgistutorials.com/en/docs/importing_spreadsheets_csv.html 4) save resulting vector dataset as .kml http://www.igismap.com/convert-shapefile-kml-qgis/ 5) import kml file to google earth http://www.google.com/earth/learn/advanced.html#tab=...


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 ...



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