<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;">Thanks Ken and Frank. <br>After some more research, I found this A2M tool from Bullzip and used it to move access to mysql. We will be moving forward with that, and using Access as a front end to use Forms and other reports for the data on mysql that mapguide can also attach to.<br><br>Now to get Mapguide to use the mysql DB!<br>Thats the next step.<br>Thanks you two!<br><br>
<blockquote webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size: 10pt; color: black; font-family: verdana;">
<div >
-------- Original Message --------<br>
Subject: Re: [mapguide-users] Microsoft Access DB in Mapguide 1.2 on<br>
Linux<br>
From: Frank Warmerdam <warmerdam@pobox.com><br>
Date: Sun, January 11, 2009 6:17 pm<br>
To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><br>
<br>
Kenneth Skovhede, GEOGRAF A/S wrote:<br>
> AFAIK, there is no really great method for using Access on Linux.<br>
> <br>
> Conversion to MySQL should be fairly easy:<br>
> <a href="http://www.bullzip.com/products/a2m/info.php" target="_blank" mce_href="http://www.bullzip.com/products/a2m/info.php">http://www.bullzip.com/products/a2m/info.php</a><br>
> <br>
> Regards, Kenneth Skovhede, GEOGRAF A/S<br>
> <br>
> <br>
> <br>
> ray@rayholtz.com skrev:<br>
>> Has anyone gotten an MSAccess database to work with Mapguide 1.2 on <br>
>> Linux and How?<br>
>> or second question:<br>
>> Has anyone converted an Access database to a mysql database to use <br>
>> with Mapguide, and how?<br>
<br>
Ray,<br>
<br>
Mateusz Loskot got OGR's PGeo driver working on linux using mdbtools, and<br>
documented his steps at:<br>
<br>
<a href="http://trac.osgeo.org/gdal/wiki/mdbtools" target="_blank" mce_href="http://trac.osgeo.org/gdal/wiki/mdbtools">http://trac.osgeo.org/gdal/wiki/mdbtools</a><br>
<br>
But my opinion is that this is a pretty difficult to setup situation and<br>
fragile at the best of times.<br>
<br>
Best regards,<br>
-- <br>
---------------------------------------+--------------------------------------<br>
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<br>
light and sound - activate the windows | <a href="http://pobox.com/%7Ewarmerdam" target="_blank" mce_href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</a><br>
and watch the world go round - Rush | Geospatial Programmer for Rent<br>
<br>
_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank" mce_href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div>
</blockquote></span></body></html>