This will work if the users can produce all the sql. I'm hoping to give them 50/50 where they can browse a table and do simple gui updates like changing info in a certain column without having to type out all the sql to do it.
-----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 5:24 PM To: CF-Talk Subject: RE: Access db interface <cfquery name="myQry" datasource="myaccessdsn"> #form.query# </cfquery> <cfdump var="#myQry#"> That should probably do the trick. Of course it's very unsafe, and will allow people to do anything they want to the db, which is sort of the idea, I guess. Russ > -----Original Message----- > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > Sent: Monday, October 29, 2007 4:57 PM > To: CF-Talk > Subject: Access db interface > > is there any open source "admin" style interface from CF to an MS > access database to give access to raw tables information or a query > window or anything of this type? > > Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4