[Geomedia-l] Access DB sharing

[Jim Post]

Another mystery solved...Thanks to Paul for helping identify the problem…He said:
It is entirely possible there's another problem at play.  Microsoft gives Access databases the ability to link data from other databases.  Microsoft's strategy forces file locks once the data accessed by these links is touched.  Please check your MDB to verify that all tables are actually Access tables and not links to other databases.

We found the non-gm application was hitting a link to our db and not the actual table.  The programmer is going to use another strategy to get at our data…something involving a “quick read” of our table…about that point my eyes glazed over.   Next year they promise we are moving to sql server…which should solve all of our troubles.  ☺

Thanks for the help.

jp

________________________________________
From: geomedia-l-bounces at lists.directionsmag.com [mailto:geomedia-l-bounces at lists.directionsmag.com] On Behalf Of Jim Post
Sent: Friday, August 18, 2006 10:29 AM
To: geomedia-l at lists.directionsmag.com
Subject: [Geomedia-l] Access DB sharing

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