<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=555123907-11102002><FONT face=Arial color=#0000ff size=2>Hi
Shaun,</FONT></SPAN></DIV>
<DIV><SPAN class=555123907-11102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=555123907-11102002><FONT face=Arial color=#0000ff
size=2> there is not direct support for MS Access data in MS
as I know. But you may use mapscript to build application showing your data
on the map. We use this approach for points of interest stored in
MySQL database at this site: <A
href="http://www.kutnahora.info">http://www.kutnahora.info</A>. You can find
also Perl example at MapServer test suite <A
href="http://maps.dnr.state.mn.us/mapserver_demos/tests/">http://maps.dnr.state.mn.us/mapserver_demos/tests/</A> -
see live earthquake mapping.</FONT></SPAN></DIV>
<DIV><SPAN class=555123907-11102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=555123907-11102002><FONT face=Arial color=#0000ff size=2>Stepan
Kafka</FONT></SPAN><FONT face="Times New Roman"><FONT size=2><SPAN
class=555123907-11102002><FONT face=Arial color=#0000ff><FONT size=2><BR>Help
Service Remote Sensing<BR>tel: +420-327514118<BR><A href="mailto:kafka@email.cz"
target=_blank>mailto:kafka@email.cz</A><BR><A href="http://www.bnhelp.cz"
target=_blank>http://www.bnhelp.cz</A> </FONT></FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face="Times New Roman"><FONT size=2><SPAN
class=555123907-11102002><FONT face=Arial
color=#0000ff> </DIV></FONT></SPAN></FONT></FONT>
<DIV><FONT face="Times New Roman"><FONT size=2><SPAN
class=555123907-11102002> </SPAN>-----Původní zpráva-----<BR><B>Od:</B>
owner-mapserver-users@lists.gis.umn.edu
[mailto:owner-mapserver-users@lists.gis.umn.edu]<B>za uživatele</B> Shaun
Kolomeitz<BR><B>Odesláno:</B> 11. října 2002 0:34<BR><B>Komu:</B>
mapserver-users@lists.gis.umn.edu<BR><B>Předmět:</B> [mapserver-users] Dynamic
web maps using MS Access<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid"><FONT
face=Arial color=#0000ff size=2></FONT><BR><FONT face=sans-serif size=2>Dear
mapserver-users,</FONT> <BR><BR><FONT face=sans-serif size=2>I have a mate who
is interested in using mapserver to display a dynamic (regularly updated)
Access database.</FONT> <BR><BR><FONT face=sans-serif size=2>We are only
talking up to about 10 000 records so I thought he could do something like
-</FONT> <BR><FONT face=sans-serif size=2>1. Get Access to regularly write the
tabular info out to a text file (either as records are updated or at regular
intervals)</FONT> <BR><FONT face=sans-serif size=2>2. Get a cron job to
translate the text file to a shapefile and index it</FONT> <BR><FONT
face=sans-serif size=2>3. My guess is that mapserver would then read the new
data provided it wasn't already involved in reading the file/indexes.</FONT>
<BR><FONT face=sans-serif size=2>My concern is that using this approach there
is a potential for file contention/locking to stuff things up.</FONT>
<BR><BR><FONT face=sans-serif size=2>Is there a simpler approach that someone
else can think of for using dynamic data from Access to display using
mapserver ?</FONT> <BR><FONT face=sans-serif size=2>(and yes I already asked
whether he could drop Access and do it all in mapserver - no go
unfortunately).</FONT> <BR><BR><FONT face=sans-serif size=2>I've searched the
archives but there are no examples / suggestions for dynamic mapping from MS
Access (personally I'd rather use MySQL or POSTGIS).</FONT> <BR><BR><FONT
face=sans-serif size=2>TIA,<BR>Shaun Kolomeitz<BR><BR>eBusiness Manager,
Toowoomba City Council<BR>Phone: 07 4688 6863<BR>Mail
to:S.Kolomeitz@toowoomba.qld.gov.au<BR>-----------------------------------------------------------<BR>This
email message (and any accompanying file attachments) may contain confidential
or privileged information and is intended for the sole use of the addressee(s)
named above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify Toowoomba City Council immediately and destroy any copies of the
original message. Any unauthorised review, use, alteration, disclosure
or distribution of this email (including any attachments) by an unintended
recipient is prohibited. While all care is taken, Council cannot
guarantee that this email message (and any accompanying file attachments) are
free of viruses. The Council accepts no responsibility for the content
of any email which is sent by an employee which is of a personal nature or
which represents the personal view of the sender.
</FONT></BLOCKQUOTE></BODY></HTML>