Hot answers tagged ms-access
6
You are in for a world of hurt (but I know that part of the answer doesn't help). If you don't mind the reduced speed - put it on a network share where only a few users have write permissions to the file and the others only have read.
From ESRI-L (in the comment below)
Give all users full file permissions to the folder (allowing them to create, read and ...
5
Caveat: I've not tried this, so I'm willing to bow to anyone with direct experience.
You can connect to an ODBC datasource in the "add vector layer" dialog, just select "database" as the source type and ODBC as the database type. QGIS uses the ODBC driver for OGR, so the same caveats will apply - that is you will need a table called GEOMETRY_COLUMNS and so ...
5
To save yourself a bit of code you could use the geoprocessor and call DataManagementTools.CopyRows. See also: How to run a geoprocessing tool
e.g.:
// Create the geoprocessor.
Geoprocessor GP = new Geoprocessor();
// Create the tool process object.
ESRI.ArcGIS.DataManagementTools.CopyRows copyrowsTool = new
...
4
You can do both, kinda. If you wanted, which would be a good thing to do, make a Personal Geodatabase (which is a MS Access DB). This will allow you to store all the spatial data and any tabular data in one DB. You will also be able to access the tables in MS Access. There are limitations, the ones imposed by MS Access; a large one being the 2GB size ...
4
If you're looking to get your data into an access database you could skip the middle conversion step entirely (or rather have ArcGIS handle it for you) by transferring your data to a personal geodatabase, which in reality is an access database.
From ArcGIS you can use the Create Personal Geodatabase tool to create the access database, and then you should be ...
4
I think you should take into account that personal geodatabase is created and accessed through ESRI clients, following proprietary patterns. MsAccess is not a spatial database on its own (it does not provide a spatial data model, so obviously no spatial data loading capabilities, spatial indexing or extended spatial SQL), so ESRI manages spatial information ...
3
If I have this correct -- biggest constraint is that you must use the local municipal data as the geocoding reference data. This wasn't clear in your original question.
I'll give you the ArcGIS answer -- since that is available to you and what I know.
You need to create a ArcGIS locator from the municipal data, i.e. the reference data. This is your ...
3
If you're interested in PostGIS, you might want to visit the BostonGIS website. They have great material to get you started. You can also start with OpenGeo's introduction to PostGIS workshop.
PostGIS has a shapefile importer that you can use to load your shape files. As for your accdb files, you might want to convert them to SQL first. Bullzip has this ...
3
MS Access is not able to do spatial operations, at least not in the way those used to using OGR standard spatial databases may be familiar with.
Functions such as ST_Within, ST_Intersects and the dedicated geometry types simply don't exist.
Now, that's not to say that you can't work with co-ordinate values, but you'll have to treat them as normal decimal / ...
3
Esri's online help (see two links below as examples) discourages users from opening Personal Geodatabases stored in Microsoft Access using Access so I think your phrase "futile because pgdb technology is proprietary and no detailed publicly available knowledge exists" probably sums it up.
http://support.esri.com/es/knowledgebase/techarticles/detail/31599
...
3
You should be able to use the AccessWorkspaceFactory co-class even though it's not a personal geodatabase. You could also use ADO.NET. I am not sure why your code isn't working but I do know that working with property sets is an exercise in frustration.
3
MS Access doesn't know what an SDE feature class is, so you don't need to do anything special to connect to a "spatial" database.
Feature class attributes are conveniently stored in tables that match the name of the feature class.
You can directly connect to the underlying SQL database and work with the tables. However, beware of adding new rows or making ...
3
With version 10 you need to explicitly initialize the license for the software; so that it knows what level to look for and what to check out. You can see the support doc to get you started. So you will want to have in your form a string to activate your license; then when you dispose of the form to return the license.This .Net sample gives you the major ...
3
If your mdb table has a shape field it should already be esri data.
Does it contain an OID, FID or GUID as well?
Edit: >
Yes OBJECTID is the one I forgot to put in the list.
If you view the db in arccatalog you should see icons
for the tables that have geodata in them. Other tables will have a table icon.
My example shows the table icons first, then ...
3
Try the install Microsoft Data Access Components (MDAC) 2.8 SP1
http://www.microsoft.com/downloads/en/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en
3
While I am still interested in hearing if there are other options available, I did come across a message post that mentioned this was possible using the eVis Plugin.
The documentation describes in the Database Connection section how you can connect to an MS Access or ODBC connection to create XY point locations from the database, without creating a static ...
3
an alternative approach would be to move the data to postgis. you can read the csv-file directly with the postgresql copy-command. then you can create points fom the xy-fields.
then if you want to use some reports or other funtionality in access you can connect to postgis from access.
the benefit would be that you put the spatial data where it belongs, in ...
3
Why dont you import the MS tables into a Geodatabase? Linking from a static MS database table may not produce the results you are looking for, as you will need/want to load the data (maybe multiple data layers) and open it into ArcMap. You may also what to symbolize these layers. If you are planning on viewing this in ArcMap, why not build a MXD project ...
2
As Ryan Dalton said you can use OGR2OGR.
The FWTools binaries for windows seem to have ESRI Personal Geodatabase support built in. You can easily export data using the following command:
ogr2ogr -f "PostgreSQL" PG:"host=localhost user=someuser dbname=somedb password=somepassword port=5432" C:\GISData\Geonames.mdb -a_srs EPSG:26986
CREDITS: the above ...
2
I am about to play around with GeoKettle http://www.spatialytics.org/projects/geokettle/ this perfoms ETL on various datasets, the data I have is in CSV, so I would imagine that if Geokettle does not natively support Access you can dump it to csv.
2
I have been told that it is not possible to permanently sort a table in most DBMSes because of the way they are optimized, they can return rows in an arbitrary order. I am not sure but I would guess this also applies to Access databases. You could create a view in your DBMS that applies an ORDER BY clause if this is that important to you.
2
Here are my two ideas:
Most county Auditor Departments have a parcel GIS layer (that is in a mapable format). You could contact this department to see if you can obtain this layer, then do a table join based on common parcel ID field to your table.
If you database has address information you could geocode that against the U.S Census Bureau TIGER Street ...
2
I do this... but its probably not the greatest approach
public bool CreateFileGDB(ref string error, string fullshapefilepath, String shapeFileDirectory, String shapeFileName, string badfields, ShapefileType shapefiletype, string Style )
{
try
{
string projectionfile = ...
2
There is good news and bad news:
The good news is that ArcGIS does support geodata in an as Access database, as Ryan Garnett states in his answer..
The bad news is: Although geodata is placed in Access, the structure of a geodatabase is very complex. Thus, you should not expect to be able to update data directly in Access.
Fortunately ArcGIS is packed ...
1
if you use win7 64 bit:
Probably, you configure the wrong databaseinterface.
Use this file:
%systemdrive%\Windows\SysWoW64\Odbcad32.exe
to configure it.
Its not the same as you reach by mouseklicks.
if you use mysql-db with odbc: you have to install the right driver
Maybe it helps to read / gtranslate this website
greets
kreike
1
If you zoom to the extent of your xy data,
Then select the window so you only get the records you want.
(any way you can get that selection is acceptable).
Ensure that the mxd projection is set to the projection you want to output.
Then export the data from the table of contents (not the attribute table).
Make sure that you use the selected features ...
1
You might want to check out the Sort tool.
This tool reorders, in ascending or descending order, records in a feature class or table based on field values. The reordered result is copied to a new dataset.
1
If you have Access 2010 you can do this:
http://www.youtube.com/watch?v=GHoy6hsAltc
If not, then perhaps one of these links may help:
https://groups.google.com/forum/?fromgroups=#!topic/microsoft.public.access/jZnlHxayF_g
http://www.utteraccess.com/forum/Call-MapQuest-access-t582734.html#Post582734&Zp=
...
1
Untested, but this should work: Create a personal geodatabase, import file-gdb into that, then open the resulting .mdb in Access 2007 and upgrade it from the Access side. If any of the source feature classes exceed 2gb you'll need to do add some logic for splitting things into pieces and recombining.
1
If you add an Excel table to the ArcMap document before running the Report Wizard, that table is available to the Report Wizard (reporting tool).
The table doesn't need to be shown on the map, it just needs to be included in ArcMap's table of contents. To add it, click Add Data, navigate to then double-click the Excel file, and choose the appropriate table ...
Only top voted, non community-wiki answers of a minimum length are eligible
