[Geomedia-l] Access DB sharing

[Carl Von Stetten]

Jim,

This is a common problem with Access databases.  Within some of our 
workspaces, we link some data-only tables from an Access database to our 
SQL Server GeoMedia warehouse. We have experienced the same issues with 
database locking.  My suggestion  with regard to the application is to 
modify it so that id does not require Exclusive access.  GeoMedia 
requires Exclusive access because it has to be able to create new tables 
when you execute an Output To Feature Class.

Depending on the size of your collection system warehouse, you might 
want to consider moving to SQL Server.  Central Contra Costa Sanitary 
District (my employer) has 130K+ parcels, 42K+ sewer mains, 48K+ sewer 
structures, and numerous other features that we manage in GeoMedia by 
multiple concurrent users.  Performance in an Access warehouse, even if 
it was only being accessed by one user at a time, would be absolutely 
dreadful.

HTH,
Carl


Jim Post wrote:

> We have a geomedia access database that contains our collection system 
> information.  Our IT department developed a non-geomedia application 
> which connects to our database.  However, the application and geomedia 
> seem to be fighting over this connection.  Whoever is connected first 
> wins access to the db, and if you try to connect after that first 
> connection has been established you are out of luck.  We can resolve 
> this by using a read-only connection in GM but we would like to 
> eliminate this problem by modifying the programming of the 
> non-geomedia application.  The application doesn't need to have edit 
> access to our database so I am hoping there is a way to connect read 
> only from within the application.
>
>  
>
> Can anyone offer a solution?
>
>  
>
> Thanks,
>
>  
>
> Jim Post
>
> GIS/CAD Specialist
>
> (608)222-1201x367
>
> Madison Metropolitan
>
> Sewerage District
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>GeoMedia-l mailing list
>GeoMedia-l at lists.directionsmag.com
>http://www.directionsmag.com/mailman/listinfo/geomedia-l
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.directionsmedia.net/pipermail/geomedia-l/attachments/20060818/74695f7d/attachment.html