Or, rather than running in Access at all, you could convert the db to MySQL, PostrgeSQL, MSSQL, or some other database type that will give you a higher degree of scalability and performance.
Dave Watts wrote: >>Problem: >> >>We need to access a data source on a network server different >>from the one that ColdFusion is running on. When I try and >>add a new Data Source in the ColdFusion Administrator and >>browse the network, it will ONLY show local drives - no >>drives on the other network server. >> >>Environment: >> >>ColdFusion is running on a W2K3 Server with IIS. We even did >>a "clean" install of the W2K3 Server to make sure everything >>was set correctly. Right now, the trial version of >>ColdFusion is installed to make sure everything that the >>programmer has done will work because he did his programming >>on his local machine that is not part of our network. >> >>All of the services (Application Server, ODBC Agent, ODBC >>Server, Search Server, JRun Admin Server & JRun CFusion >>Server) are running "logged on as" a user account setup with >>full rights to the network server I am trying to access. The >>server we are trying to access is a W2K3 SBS that contains >>the order information we need to make available to users of >>our new web application. > > > Network shares will not show up in the CF Administrator. I don't know if > drive mappings to network shares will show up or not, but I suspect they > won't. You don't have to use the browser applet, though. You can just put in > the path using the appropriate drive mapping. You can probably even enter a > UNC path, although I haven't tested that. > > You should first log into a shell with that user account to ensure that it > can get to these resources. > > However, you should be aware that using an Access database stored on a > network share will be VERY, VERY SLOW. I would strongly recommend that you > copy it to the application server, and use it there. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
