I need to prevent people uploading an access database for a few minutes at a time, and I want to know if locking it while using it as a DSN will do that. And it has to happen without human intervention. Here's my scenario ...
I have users uploading an access database from legacy systems, containing update information for my online database. Their systems gather the changes, put them into the access database, then automatically FTP that to a central server (Yes, i know but for now I'm stuck with that - rewriting their legacy systems is on the agenda but it's a big job with LOTS of ramifications so for now it's not an option!) So my CF9 system has to read that access database, and use the data contained within to update my SQLServer2005 data that serves the online database. So far so good. But there are updates that need passing back the other way too. So I have to gather updates for the remote systems from the online database, package them up into an access database and put them into the FTP Folder for the remote systems to download when they get round to it. Here's my issue ... how to make sure that while I'm processing the updates, and preparing the package for download no one can upload a new access database that will be over-written when I complete my processing. I need to lock the FTP Folder (ideally i'd like to lock out all FTP access while this is going on but since i am using shared hosting i dont have access to that) or in other ways prevent people uploading while i'm processing (shouldn't be more than a minute at a time) then write a new Access database for them to download, then open access to the FTP again. At the moment the only way i can think to achieve this is to programmatically make the database a dsn, then unlock it again when I'm done processing. That doesnt seem very elegant to me, but then this whole scenario isnt very elegant. But does anyone have any better ideas? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.