Jake, He may be able to use this approach.
http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx Basically it uses ANY Access DSN that is previously set up as a proxy. So you set up just one in the DSN and it serves as a proxy for any access files you wish to put on the server. FYI (I shouldn't say this) but previous versions shipped with an installed access DB already set up for - cfsnippets I think. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Jake Churchill [mailto:[email protected]] Sent: Wednesday, February 25, 2009 3:35 PM To: cf-talk Subject: Access DB without datasource I have a friend (yes really) who is working on a project that requires him to have an access database but he does not have access to the CF Administrator so he is wondering if there is a way around this. The only thing I could come up with is to attempt to either run the query with java or create the datasource with java (Context class). I thought I'd throw this out to the list to see if anyone has any other ideas. Thanks! -Jake ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
