This has to happen automatically because the process is initiated by an event when a manager logs on and maintains a record in the product file. When that happens, it causes the system to generate a new database for the users around the country to download when they next log on. So i need to connect and disconnect from the access database programmatically.
Are you meaning when I set the DSN up in the first place, i uncheck the "Maintain Database Connections" checkbox and that should do the trick for future connects/disconnects?? Our control panel doesnt set access DSNs up that way but i can get my sysadmin to set the DSNs up manually through the administration interface instead though. 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 On Thu, Sep 16, 2010 at 2:31 AM, Rick Root <[email protected]> wrote: > > On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels <[email protected]> wrote: >> >> unchecking the "maintain database connections" in the DSN may work. > > WE used to do this back in the 90s when I was still using Access > databases for web sites :) > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
