[mapserver-users] Dynamic web maps using MS Access

[Shaun Kolomeitz]

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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20021011/e5352025/attachment.htm>