[mapserver-users] Dynamic web maps using MS Access

[Lowell Filak]

Allowing for the other suggestions, if you still prefer going the ascii file route there happens to be an article in the October SysAdmin dealing with Access, Filemaker, & Excel -> MySQL, Postgres. All the code can be downloaded directly at: http://www.sysadminmag.com/code/ -> 2002 -> October
Lowell F.

The following message was sent by "Shaun Kolomeitz" <S.Kolomeitz at toowoomba.qld.gov.au> on Fri, 11 Oct 2002 08:34:25 +1000.

> Dear mapserver-users,
> 
> I have a mate who is interested in using mapserver to display a dynamic 
> (regularly updated) Access database.
> 
> We are only talking up to about 10 000 records so I thought he could do 
> something like -
> 1. Get Access to regularly write the tabular info out to a text file 
> (either as records are updated or at regular intervals)
> 2. Get a cron job to translate the text file to a shapefile and index it
> 3. My guess is that mapserver would then read the new data provided it 
> wasn't already involved in reading the file/indexes.
> My concern is that using this approach there is a potential for file 
> contention/locking to stuff things up.
> 
> Is there a simpler approach that someone else can think of for using 
> dynamic data from Access to display using mapserver ?
> (and yes I already asked whether he could drop Access and do it all in 
> mapserver - no go unfortunately).
> 
> 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).
> 
> TIA,
> Shaun Kolomeitz
> 
> eBusiness Manager, Toowoomba City Council
> Phone: 07 4688 6863
> Mail to:S.Kolomeitz at toowoomba.qld.gov.au
> -----------------------------------------------------------
> 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.